Submit query via the Impala api service on the CDP gateway page

ST1 — Thu, 28 Nov 2024 17:29:56 GMT

Hello,

On the CDP gateway page a number of API services are listed among which Impala. The endpoint has the format https://host:port/gateway/cdp-proxy-api/Impala. My question is can this endpoint be used to submit actual queries? And, if yes, is there any documentation available?

Thank you!

Re: Submit query via the Impala api service on the CDP gateway page

ChethanYM — Thu, 13 Feb 2025 13:42:53 GMT

Hi, I have not tested it may be you can try something like this and see if that works.

curl -X POST "https://cdp.company.com/gateway/cdp-proxy-api/Impala/api/v1/query" \ -H "Authorization: Bearer YOUR_ACCESS_TOKEN" \ -H "Content-Type: application/json" \ -d '{ "query": "SELECT * FROM sales_data WHERE date >= current_date - interval 7 days;", "database": "analytics_db", "async": false }'

Cloudera API overview:

https://docs.cloudera.com/cdp-public-cloud/cloud/api/topics/mc-api-overview.html?utm_source=chatgpt.com

Regards,

Chethan YM

question Re: Submit query via the Impala api service on the CDP gateway page in Support Questions

Submit query via the Impala api service on the CDP gateway page

Re: Submit query via the Impala api service on the CDP gateway page