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

Error while executing SQL query on Kylin 2.0 Beta version

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Resolved
    • Affects Version/s: v2.0.0
    • Fix Version/s: Future
    • Component/s: Query Engine
    • Labels:
      None
    • Environment:
      CentOS
    • Flags:
      Important

      Description

      Here FACT_MAC_PV is my fact table while MAC_PORTRAIT is my lookup table. FACT_MAC_PV.CLMAC is my foreign key and MAC_PORTRAIT.CLMAC is my primary key. The problem is that when I try to run this query:
      SELECT count(DISTINCT "MAC_PORTRAIT"."CLMAC")
      FROM "DEFAULT"."FACT_MAC_PV" "FACT_MAC_PV"
      INNER JOIN "DEFAULT"."MAC_PORTRAIT" "MAC_PORTRAIT" ON ("FACT_MAC_PV"."CLMAC" = "MAC_PORTRAIT"."CLMAC");
      on Kylin 2.0, it gives me the error which I upload in attachment.
      However, it works fine on Kylin 1.6 under exactly the same environment and cube settings. I was wondering if this is a problem in beta version or not?

        Attachments

        1. SQLerror.txt
          10 kB
          Zhuoran Lyu

          Activity

            People

            • Assignee:
              liyang.gmt8@gmail.com liyang
              Reporter:
              zhuoran Zhuoran Lyu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: