kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zhao jintao (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-3941) Save query id, sql id and sql statement in hive and add to system cube.
Date Tue, 09 Apr 2019 08:38:00 GMT
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)

Mime
View raw message