Automating Big Data Studio Hive Queries

[Tim Maher]

HI,

I have a set of Hive Queries in Big Data Studio and I was wondering if it is possible to automate these? Could this be accomplished from Data Integration Studio?

Thanks for your help!

Tim

[Karthikeyan SankaraVadivel]

Hi Tim, 

In Data Integration Platform, we have SelectHiveQL processor to execute the hive(HQL) SELECT query against a Hive tables. Select query result will be converted to Avro or CSV format. Based on your requirement you can transform the resultant data in Data integration platform.  

For more details, refer -  https://help.syncfusion.com/data-integration/processors/selecthiveql  

We can also schedule your query executions by scheduling the SelectHiveQL Processor, Please follow the steps to schedule the processor by the below link . 

Link - https://help.syncfusion.com/data-integration/user-guide#scheduling-tab  

Please let me know if you need more details on this.  

Regards, 

Karthikeyan S