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)
