Query History

All the queries that you executed in Kylin will be saved in query history, you can check it out in the left side navigation bar Query -> History.

This page saves the basic information of queries, such as query time, SQL statement, query user, etc. This helps you to record query behaviors, which enables you to better manage and optimize the models. This chapter will presents you the content of query history page.

View Query History

Click the Query History button in the left navigator bar, you will see all the queries with basic information.

View Query History
View Query History

Each line in the list is a query history record. The meaning of the columns are as follows:

  • Start time: The time the query was submitted.

  • Execution Time: The time taken to complete the query. If the query fails, it is displayed as blank.

  • MDX Statement: MDX statement that was executed.

  • Dataset Name: The dataset used for the query.

  • Query Status: There are several states as follows:

    Success

    Failure

  • Application: The type of BI that submitted the query.

  • Query Node: The service nodes that handle the query.

  • User: MDX for Kylin user who submitted the query.

History Details

When you click on the arrow icon on the left side of a query analysis, the details of the current MDX query will be expanded. The information is divided into two parts: query details and SQL statements. The query details show the basic information of MDX scripts and queries (such as: Session ID, query status, etc.), SQL statements show related SQL scripts.

View History Details
View History Details

Note: Only the first 1000 rows of Query can be seen in the query details. You can click the copy button in the upper right corner of the query statement box to copy the complete statement.

Query Details

Click View in More Information to show more details:

MDX Query Details
MDX Query Details

Meaning of relevant details:

  • Query ID: MDX query execution ID

  • Execution Time: the total time of the entire MDX query (including the total time of preprocessing, SQL queries, etc.)

  • Use MDX Cache : query whether to hit MDX cache

  • Use Other engine: whether to use other syntax execution engine

  • Network Package: the total bytes of network throughput

  • Timeout: whether timeout in the query of processing

  • Time for Creating Multidimensional Dataset: the time for creating multidimensional dataset

  • Time for Marshall Soap Message: the time for marshall soap message

  • Dataset Name: the dataset for query to hit

  • Use Gateway : Whether the client side initiating the query uses MDX for Kylin Gateway.

SQL Statement

Select the SQL statement of query list, and then click the Detail tab to view the detailed information of the SQL query statement. As shown below:

SQL Query Details
SQL Query Details

Meaning of relevant details:

  • Query ID : SQL query execution ID

  • Number of result rows : Returns the number of rows in the result set

  • Whether to use cache : query whether to hit cache

  • System ID : internal increment number

Powered by Gitbook.            Last Modified: 2022-03-24 17:19:56

results matching ""

    No results matching ""