Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Setting a Queue When Querying a Database

kaianderson
8 - Asteroid

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.

1 REPLY 1
AZuc
Alteryx
Alteryx

@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

 

AZuc_0-1637863815988.png

 

André Zuccatti

Sales Engineer - LATAM -
Alteryx, Inc.


Labels