Table Data Is Empty on the TezUI HiveQueries Page

Question

A user logs in to Manager and switches to the Tez web UI page, but no data for the submitted task is displayed on the Hive Queries page.

Answer

To display Hive Queries task data on the Tez web UI, you need to set the following parameters:

On Manager, choose Cluster > Service > Hive > Configurations > All Configurations > Hive > Customization. Add the following configuration to yarn-site.xml:

Attribute	Attribute Value
yarn.timeline-service.enabled	true
yarn.timeline-service.webapp.https.address	#{tl_hostname}:#{tl_https_port}
yarn.resourcemanager.system-metrics-publisher.enabled	true
yarn.timeline-service.generic-application-history.enabled	true

On Manager, choose Cluster > Service > Hive > Configurations > All Configurations > HiveServer > Customization. Add the following configuration to hive-site.xml:

Attribute	Attribute Value
hive.exec.pre.hooks	org.apache.hadoop.hive.ql.hooks.ATSHook
hive.exec.post.hooks	org.apache.hadoop.hive.ql.hooks.ATSHook
hive.exec.failure.hooks	org.apache.hadoop.hive.ql.hooks.ATSHook

Data display on TezUI depends on the TimelineServer instance of Yarn. If the TimelineServer instance is faulty or not started, you need to set yarn.timeline-service.enabled to false in yarn-site.xml. Otherwise, the Hive task fails to be executed.

Parent topic: Common Issues

Previous topic: Yarn Logs Cannot Be Viewed on the TezUI Page

Next topic: Using Yarn