[ https://issues.apache.org/jira/browse/KYLIN-2550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15973643#comment-15973643 ]
liyang commented on KYLIN-2550: ------------------------------- Beta3 is available now. Do let us know if the problem stays. Thanks! > 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)