How to connect UiPath to Qubole Hive cluster and run a query

125 views Asked by At

One of the teams using RPA in my company wants to automate reporting that is run in Qubole - Hive environment. The initial approach is to unleash the robot to log in to Okta, then Workbench in Qubole, run the query, and download results.

Is there a more straightforward way to do it using UiPath Studio you know about?

2

There are 2 answers

0
Pradeep Gouru On

You can also utilize REST API calls REST API Reference to submit queries to qubole.

0
Mohit Yadav On

I'm not much familiar with the UiPath studio but if UiPath has ODBC/JDBC interface to connect to different data sources, then you can make use of the Qubole ODBC or JDBC driver (refer: ODBC Driver and JDBC Driver ) to directly fire the hive SQL query on Qubole Analyse and the driver will return the results to UiPath.