-
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
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?