Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
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

avatar
Expert Contributor

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

avatar
Expert Contributor

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

avatar
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: