Created on 10-03-2017 08:32 AM - edited 09-16-2022 05:20 AM
Hello All,
Is it possible to execute a query and receive a result in the API, the same as the queries tab in Impala?
Created 10-03-2017 08:36 AM
Referring to what can be done with impala-shell as well, but wondering if I can do it via Cloudera API
Created 10-03-2017 09:27 AM
@Pej,
Cloudera Manager does not have an API entry point to allow you to execute queries. You can view queries and cancel them, but CM will not execute the queries.
For a UI to do so, you can leverage Hue.
-Ben
Created 10-03-2017 09:19 AM
Hello Pej,
The exhaustive list of all Cloudera Manager API commands is available in it's documentation. As Cloudera Manager API is designed to manage and provide information about the cluster status, it has currently no capabilities to research the data itself, like receiving the result data of Impala queries.
I'd recommend to use impala-shell or one of the available connectors (ODBC / JDBC) to interface with impala, depending on your specific use-case.
Regards,
Zsolt
Created 10-04-2017 06:51 AM
Thank you all!