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

Failed to query "select * from {lookup}" if a lookup table joined in two different models

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: v3.0.0-alpha2
    • Fix Version/s: v3.1.0
    • Component/s: Query Engine
    • Labels:
      None

      Description

      Steps to reproduce:
      1. Create two models with same lookup table (create snapshot)
      2. Define different columns as dimensions in the two models
      (Etc: in model ma, with column lookup.c1, lookup.c2; in model mb, with column lookup.c2, lookup.c3)
      3. Create two cubes with the two models, and build the 2 cubes
      4. Run query with "select * from

      {lookup}

      " with the 2 cubes in ready status, it should be failed with exception message like
      "
      No model found for OLAPContext, CUBE_NOT_CONTAIN_ALL_COLUMN[1_39bd1072:SSB.DATES.D_DAYNUMINWEEK, 1_39bd1072:SSB.DATES.D_DAYOFWEEK, 1_39bd1072:SSB.DATES.D_DATE, 1_39bd1072:SSB.DATES.D_DAYNUMINMONTH, 1_39bd1072:SSB.DATES.D_DAYNUMINYEAR, 1_39bd1072:SSB.DATES.D_MONTH, 1_39bd1072:SSB.DATES.D_MONTHNUMINYEAR], CUBE_NOT_READY, CUBE_NOT_READY, CUBE_NOT_CONTAIN_ALL_COLUMN[1_39bd1072:SSB.DATES.D_YEARMONTHNUM, 1_39bd1072:SSB.DATES.D_YEAR], rel#218:OLAPTableScan.OLAP.[](table=[SSB, DATES],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11]) while executing SQL: "select * from DATES LIMIT 50000"
      "

        Attachments

          Activity

            People

            • Assignee:
              hit_lacus Xiaoxiang Yu
              Reporter:
              nichunen nichunen
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: