Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive profiling and query performance tuning tool

avatar
Explorer

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

1 ACCEPTED SOLUTION

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
3 REPLIES 3

avatar
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login

avatar
Rising Star

@Anika S Yes, as Binu said, the Tez View of Ambari can help you analyze and troubleshoot Hive queries if you are running on a Tez execution engine. Here are some resources to help guide you:

avatar
Explorer

Thank you. Will review the links.