Alteryx designer Discussions

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

Execute hive query in alteryx

Highlighted
Atom

Hi , is that possible to execute hive query in alteryx ??

Highlighted
Alteryx
Alteryx

Yes, you would want to investigate the In-Database section of the tool palette.

 

These enable you to build an Alteryx workflow, but when you press run it executes the statement within Hive. 

Atom

I wanna execute the hive query where can i write it i try it with query bluider , that's work i think iit's just for sql command 

Highlighted
Alteryx
Alteryx

I think you should be able to achieve what you are looking for using the Connect In-DB tool:

https://help.alteryx.com/11.5/index.htm#cshid=LockInInput.htm

 

This will run on your hive instance. You can then use the data stream in if you want to move the data straight to Alteryx, otherwise you have further In-DB tools to configure and run on your Hive instance.

Labels