question Re: CM_API get_impala_queries() can only grab queries from past ~11 days in Archives of Support Questions (Read Only)

CM_API get_impala_queries() can only grab queries from past ~11 days

willschlemmel — Fri, 16 Sep 2022 13:28:12 GMT

using CM_API v19

Hi,

I'm trying to utilize the CM API with Python 2 to extract a large amount of Impala queries for analysis, but whenever I utilize the get_impala_queries() function to gather queries, I can not grab any queries further than about 11 days into the past. When I actually check the host webpage, there are definitely more queries that I want to extract that occurred earlier than 11 days ago.

For example, when I run the script around now (7-16-18 16:35 UTC), I can not obtain any queries from dates earlier than 7-05-18 06:20 UTC.

Re: CM_API get_impala_queries() can only grab queries from past ~11 days

bgooley — Mon, 16 Jul 2018 19:17:11 GMT

@willschlemmel,

Please have a look at the thread here where we discuss how the API works with impala queries:

http://community.cloudera.com/t5/Cloudera-Manager-Installation/CM-API-Maximum-number-of-requests/m-p/67802/highlight/true#M13943

Check to see if you have "warnings" returned in your result and if it contains a timestamp.

Also, please show us more about your problem... you said "I cannot obtain any queries from dates earlier...." How do you know this? What do you observe exactly?