Creating system tables to run query on Hive and Tez DAG events

The Tez DAG events are exposed in the dag_data table, and the Hive query events are exposed in the query_data table in the sys database. You can run Hive queries from DAS to process these events and generate custom reports.

You need to create these system tables before you can run queries on them.
  1. From Ambari, go to Data Analytics Studio.
  2. Click Actions > Create Tables.
  3. Navigate through the table creation wizard and make sure that the operation completes successfully.
    You can view the dag_data and the query_data tables under the sys database in the DAS UI.