[
https://issues.apache.org/jira/browse/KYLIN-2725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhong Yanghong updated KYLIN-2725:
----------------------------------
Description:
System cubes are the basis of dashboard & cube planner. Dashboard & cube
planner can query on system cubes to fetch required data. Currently, we design
five system cubes. The details are as follows:
* METRICS_QUERY
** Dimension
HOST, PROJECT, REALIZATION, REALIZATION_TYPE, QUERY_TYPE, EXCEPTION,
*TIME_DIMENSIONS*
** Measure
COUNT,
MIN & MAX & SUM & PERCENTILE of QUERY_TIME_COST,
MAX & SUM of CALCITE_SIZE_RETURN,
MAX & SUM of STORAGE_SIZE_RETURN,
MAX & SUM of CALCITE_SIZE_AGGREGATE_FILTER,
COUNT_DISTINCT(hll) of QUERY_HASH_CODE
* METRICS_QUERY_CUBE
was:System cubes are the basis of bashboard & cube planner.
> Introduce a tool for creating system cubes relating to query & job metrics
> --------------------------------------------------------------------------
>
> Key: KYLIN-2725
> URL: https://issues.apache.org/jira/browse/KYLIN-2725
> Project: Kylin
> Issue Type: Sub-task
> Affects Versions: v2.0.0
> Reporter: Zhong Yanghong
> Assignee: Zhong Yanghong
>
> System cubes are the basis of dashboard & cube planner. Dashboard & cube
> planner can query on system cubes to fetch required data. Currently, we
> design five system cubes. The details are as follows:
> * METRICS_QUERY
> ** Dimension
> HOST, PROJECT, REALIZATION, REALIZATION_TYPE, QUERY_TYPE, EXCEPTION,
> *TIME_DIMENSIONS*
> ** Measure
> COUNT,
> MIN & MAX & SUM & PERCENTILE of QUERY_TIME_COST,
> MAX & SUM of CALCITE_SIZE_RETURN,
> MAX & SUM of STORAGE_SIZE_RETURN,
> MAX & SUM of CALCITE_SIZE_AGGREGATE_FILTER,
> COUNT_DISTINCT(hll) of QUERY_HASH_CODE
> * METRICS_QUERY_CUBE
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
