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

Useless filter dimension will impact cuboid selection.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v2.0.0
    • Component/s: None
    • Labels:
      None

      Description

      Query1: select count from test_kylin_fact where (cal_dt > DATE'2012-01-01') and (seller_id is null or 1 = 1)
      Query2: select count from test_kylin_fact where (cal_dt > DATE'2012-01-01')

      Q1 and Q2 return identical result but hit different cuboid: 43051 and 1310735, and result in different query performance.

        Attachments

          Activity

            People

            • Assignee:
              mahongbin Hongbin Ma
              Reporter:
              event Yifan Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: