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

NoRealizationFoundException due to creating a wrong JoinDesc

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: v3.0.0, v3.0.0-alpha
    • Component/s: Query Engine
    • Labels:
      None

      Description

      When joining with a lookup table, a column from fact table is used more than once, the JoinDesc will not be correctly generated in OLAPJoinRel, causing NoRealizationFoundException. Multimap should be used instead of Map.
      Sample Join:

      select LSTG_FORMAT_NAME, count(*)
      FROM TEST_KYLIN_FACT 
      INNER JOIN EDW.TEST_CAL_DT as TEST_CAL_DT
      ON TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.CAL_DT AND TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.WEEK_BEG_DT
      group by LSTG_FORMAT_NAME
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: