community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

Execute hive query in alteryx

Atom

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

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 

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