[jira] [Created] (KYLIN-3941) Save query id, sql id and sql statement in hive and add to system cube.

["zhao jintao (JIRA)" <ji...@apache.org>]

zhao jintao created KYLIN-3941:
----------------------------------

             Summary: Save query id, sql id and sql statement in hive and  add to system cube.
                 Key: KYLIN-3941
                 URL: https://issues.apache.org/jira/browse/KYLIN-3941
             Project: Kylin
          Issue Type: Improvement
          Components: Metrics
    Affects Versions: v2.6.1
            Reporter: zhao jintao
            Assignee: zhao jintao


Hi team:

I use kylin system cube to get sql query statistics.

But when I use system cube, I find that sql statistics can not be accurate to a single sql, so I can't directly get slow sql for further analytics.

I hope to get the sqlid and sql query statements from the system cube,so that I can analyze the slow query sql statement, guide creating kylin model and wiriting sql statement.

In my kylin system, I save sql query id, sql id, sql length and sql statement in hive, and and sql id, sql length, sql statement in KYLIN-SYSTEM cube. Can I submit my improvements to the open source community.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)