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

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.6.1
• Component/s: Metrics
• Assignee: zhao jintao
• Reporter: zhao jintao
• Due: 23/Apr/19
• Created: 09/Apr/19 08:37
• Updated: 09/Apr/19 08:37

Description

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.