Setting a Queue When Querying a Database

[kaianderson]

I'm trying to pull data into Alteryx from a Hive database, but I need to use a queue as a requirement to query from it. In a SQL developer platform, this would just be a SET statement before the main query, but I can't figure out how to do the equivalent in Alteryx.

[AZuc · Accepted solution]

@kaianderson , you may be able to do it by setting set mapred.job.queue.name=<queuename> on your ODBC Settings for Hive.

Open your Hive ODBC DSN Setup

Click on Advanced Options

Click on Server Side Properties

See if it helps