Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-3941

Save query id, sql id and sql statement in hive and add to system cube.

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • v2.6.1
    • None
    • Metrics
    • None

    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.

      Attachments

        Activity

          People

            zhao jintao zhao jintao
            zhao jintao zhao jintao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: