Hi All
I am trying to get all hive queries for last 30 days ran on my cluster.
I selected all the jobs on cloudera YARN application UI and filtered for last 30 days and also selected attribute of hive_query_string, which allows me to see the actual query.
The only issue is that cloudera restricts UI to show only last 100 jobs at a time.
Because of this i can't get details on all the other queries.
I tried to hit this api http://cluster:8088/ws/v1/cluster/apps to get all the details, two issue: there is no filter and other is there is no hive_query_string variable to filter. It just shows me all the job details.
Is there an API exposed by cloudera where i can filter and get all the hive_query_string or if i can configure the cloudera UI to show me more than 100 jobs(or just export it).
Let me know.
Thanks
AB
Abhishek