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

[#1]

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.

[#2 · Accepted solution]

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

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?