How do I see user usage stats by table in Impala Query

[#1]

Is there a Chart or way to see all the tables used by Impala for the last 6 months?

I know that in CM the Queries tab shows only 30 days of prior queries

is there a chart I can build out?

[#2 · Accepted solution]

@scratch28

You can use clouder navigator to generate this report

Login as full admin to CM 

Cloudera Management Service -> Navigator Metadata Server -> Cloudera Navigator (menu) -> search for 'impala' -> choose from left side options. You can choose upto last 365 days (or) custom period