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

[#1]

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?

[#2 · Accepted solution]

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

[#3]

@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.