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

kylin scan different in same sql

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: In Progress
    • Priority: Minor
    • Resolution: Unresolved
    • Affects Version/s: v2.3.1
    • Fix Version/s: Future
    • Component/s: Query Engine
    • Labels:
      None

      Description

      There are two sql:

      select sum(value) from test where time > 1524326400 group by id

      and

      select sum(value) from test where time > (1524931200-7*86400) group by id

      As we can see 1524326400 =(1524931200-7*86400) 

      but the second sql query slower than the first sql

      Cuboid Ids: [3904]
      Total scan count: 1157959
      Total scan bytes: 265530668
      Result row count: 34991

      Cuboid Ids: [3904]
      Total scan count: 611795
      Total scan bytes: 140681855
      Result row count: 34991

        Attachments

          Activity

            People

            • Assignee:
              yaho Zhong Yanghong
              Reporter:
              lemontsr Lemont
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: