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

query result not correct when lookup table is joined twice

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query Engine
    • Labels:
      None

      Description

      select SELLER_COUNTRY.NAME, BUYER_COUNTRY.NAME, sum(PRICE)
      FROM TEST_KYLIN_FACT
      LEFT JOIN TEST_ORDER as TEST_ORDER
      ON TEST_KYLIN_FACT.ORDER_ID = TEST_ORDER.ORDER_ID
      LEFT JOIN EDW.TEST_CAL_DT as TEST_CAL_DT
      ON TEST_KYLIN_FACT.CAL_DT = TEST_CAL_DT.CAL_DT
      LEFT JOIN TEST_CATEGORY_GROUPINGS
      ON TEST_KYLIN_FACT.LEAF_CATEG_ID = TEST_CATEGORY_GROUPINGS.LEAF_CATEG_ID AND TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_CATEGORY_GROUPINGS.SITE_ID
      LEFT JOIN EDW.TEST_SITES as TEST_SITES
      ON TEST_KYLIN_FACT.LSTG_SITE_ID = TEST_SITES.SITE_ID
      LEFT JOIN EDW.TEST_SELLER_TYPE_DIM as TEST_SELLER_TYPE_DIM
      ON TEST_KYLIN_FACT.SLR_SEGMENT_CD = TEST_SELLER_TYPE_DIM.SELLER_TYPE_CD
      LEFT JOIN TEST_ACCOUNT as SELLER_ACCOUNT
      ON TEST_KYLIN_FACT.SELLER_ID = SELLER_ACCOUNT.ACCOUNT_ID
      LEFT JOIN TEST_ACCOUNT as BUYER_ACCOUNT
      ON TEST_ORDER.BUYER_ID = BUYER_ACCOUNT.ACCOUNT_ID
      LEFT JOIN TEST_COUNTRY as SELLER_COUNTRY
      ON SELLER_ACCOUNT.ACCOUNT_COUNTRY = SELLER_COUNTRY.COUNTRY
      LEFT JOIN TEST_COUNTRY as BUYER_COUNTRY
      ON BUYER_ACCOUNT.ACCOUNT_COUNTRY = BUYER_COUNTRY.COUNTRY
      group by SELLER_COUNTRY.NAME, BUYER_COUNTRY.NAME
      order by SELLER_COUNTRY.NAME, BUYER_COUNTRY.NAME
      

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: