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

bad query performance when IN clause contains a value doesn't exist in the dictionary

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • v1.1, v1.4.0
    • None
    • None

    Description

      For example, we had a query of 39 x values in where clause and there is one
      x value not in cube, which yielded the following result:

      Duration: 60.947

      Cube Names: [olap]

      Total scan count: 2524898

      Result row count: 39

      (The log shows "Can't translate value xxx to dictionary ID, roundingFlag 0.
      Using default value \xFF")

      And we excluded the x value that is not in cube and re-run the query and got
      the another result:

      Duration: 2.477

      Cube Names: [olap]

      Total scan count: 96543

      Result row count: 38

      Attachments

        Activity

          People

            liyang.gmt8@gmail.com liyang
            qhzhou Qianhao Zhou
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: