Queries are not appearing on the Queries page
If queries are not appearing on the Queries page, then try the following:
-
Check your role. Only admin users can view queries and data of other users. Non-admin users can view only the queries that they have run.
To enlist yourself as the admin user, go to Admin Users field.
, and add your user name in theFor example,
hive,admin1,admin2
. To make all users administrators, specify an asterik (*
). -
Make sure that the DAS services are running as the hive service user.
-
Go to Base Directory for Hive Proto Hook field.
and verify whether the logs are added to the path specified in the -
Go to Tez history events directory field.
and verify whether the logs are added to the path specified in theUse the following command to get the path to the logs for Hive:hdfs dfs -ls /warehouse/tablespace/external/hive/sys.db/query_data
Use the following commands to get the paths to the logs for Tez:hdfs dfs -ls /warehouse/tablespace/external/hive/sys.db/dag_data
hdfs dfs -ls /warehouse/tablespace/external/hive/sys.db/dag_meta
hdfs dfs -ls /warehouse/tablespace/external/hive/sys.db/app_data
If you have not run any queries, then the log directories can be empty.
- Verify whether you have the required access and permission to directories specified in the
Base Directory for Hive Proto Hook and Tez history events
directory field by checking errors from
EventProcessorPipeline
in the /var/log/das/event-processor.log file. -
If you have a large number of users running Hive queries simultaneously using DAS, the connections from Hive can get exhausted. This sends the query to a queue in Hive which takes a long time to start running. This can result in the following:
-
If a query is fired from DAS, it does not return any log or indicate that the query has been queued.
-
The query does not appear on the UI, because no event is received by DAS.
Evaluate your cluster usage. You may need to add more machines to the clusters to resolve this issue.
-