Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Setting a Queue When Querying a Database

kaianderson
8 - Asteroid
‎11-24-2021 03:51 PM

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.

Reply

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
AZuc
Alteryx Alumni (Retired)
‎11-25-2021 10:10 AM

@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.


Reply
view community events calendar
designer new user guide
Labels