Support Questions
Find answers, ask questions, and share your expertise

How to send data from Hive(which is stored on Adls layer )to rest API

New Contributor

We are using cdp 7.2.x and ADLS GEN2 public cloud .

I have a requirement ,related to which one team wants to consume the data via rest Api .

1. They expose their rest api and then using some tool or code we can send data from Hive layer to their rest api . Can we do this via NIFI?

2. we create rest api on top of our Hive layer in ADLS and the other team can consume the data from this API. 

Can you Please suggest how to proceed on both options . Are they feasible?

 

1 ACCEPTED SOLUTION

Accepted Solutions

Cloudera Employee

Hive doesn't provide the rest API itself. The user has to connect Hive by using JDBC/ODBC to fetch the data. Alternatively, you may write the query result to the ADLS and fetch the data via ADLS rest API.

https://docs.qubole.com/en/latest/user-guide/engines/presto/insert.html

View solution in original post

2 REPLIES 2

Cloudera Employee

Hive doesn't provide the rest API itself. The user has to connect Hive by using JDBC/ODBC to fetch the data. Alternatively, you may write the query result to the ADLS and fetch the data via ADLS rest API.

https://docs.qubole.com/en/latest/user-guide/engines/presto/insert.html

View solution in original post

Community Manager

@nidhi300, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: