[jira] [Created] (KYLIN-2550) Error while executing SQL query on Kylin 2.0 Beta version

["Zhuoran Lyu (JIRA)" <ji...@apache.org>]

Zhuoran Lyu created KYLIN-2550:
----------------------------------

             Summary: Error while executing SQL query on Kylin 2.0 Beta version
                 Key: KYLIN-2550
                 URL: https://issues.apache.org/jira/browse/KYLIN-2550
             Project: Kylin
          Issue Type: Bug
          Components: Query Engine
    Affects Versions: v2.0.0
         Environment: CentOS
            Reporter: Zhuoran Lyu
            Assignee: liyang
            Priority: Critical
             Fix For: Future
         Attachments: SQLerror.txt

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? 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)