[KYLIN-2550] Error while executing SQL query on Kylin 2.0 Beta version

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Resolved
• Affects Version/s: v2.0.0
• Fix Version/s: Future
• Component/s: Query Engine
• Environment: CentOS
• Flags: Important
• Assignee: liyang
• Reporter: Zhuoran Lyu
• Created: 17/Apr/17 04:55
• Updated: 19/Apr/17 07:58
• Resolved: 19/Apr/17 07:58

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?