1) where can I run these kind of queries?
In CM -> Charts -> Chart Builder builder you can run tsquery. Refer to this link:
2) where can I find the attributes like category and clusterName in cloudera?
In Chart Builder text bar, write an incomplete query like:
Below the text bar there is Facets, click on More, select any Facets you want, for example you select clusterName, then you will see a the clusterName shows in the chart's title.
Then you can complete your tsquery: SELECT get_file_info_rate where clusterName=xxxxx
If you want to build impala related charts, suggest to firstly review the CM > Impala service > Charts Library, many charts are already there for common monitoring purpose. You can open any of the existing charts to learn how to construct the tsquery and then build your own charts.
Another very good place to learn is CM > Charts > Chart Builder, at right side you will see a "?" button, click on it you will see many examples and you could just cllick "try it".
If the answer helps, please accept as solution and click thumbs up.