Tracking Hive on Tez query execution
You need to know how to monitor Hive on Tez queries during execution. Several tools provide query details, such as execution time.
- Some select queries can be converted to a single FETCH task instead of a MapReduce task, minimizing latency. A value of none disables all conversion, minimal converts simple queries such as SELECT * and filter on partition columns, and more converts SELECT queries including FILTERS.
Above this size, queries are converted to fetch tasks.
Increasing the static pool does not speed reads and there is not recommended.
- In Cloudera Manager, click , and search for fetch.
- Accept, or change, the default values of the fetch task properties.
Navigate to the HiveServer log directory and look at the log files.
In Cloudera Manager, you can find the location of this directory as the value of HiveServer2 Log Directory.
- In Cloudera Manager, click , and click to the HiveServer Web UI.
- Use Hue to track query progress.