Hi I am in the process of performance tuning hive queries and also would like to profile the user access/queries run . Just wondering if there is an easy to install/use tool that can be used with hive. I have done similar exercise in sql server and have used the tools there but was hoping if I can get a similar tool setup for hive. we have several queries that have sub queries within them and aggregates and are taking close to 10 seconds while executing for the first time. There is lot of adhoc queries as well so putting partitions or index might or might not help. Please let me know any suggestions. Thanks ... View more