[
https://issues.apache.org/jira/browse/KYLIN-2550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
liyang resolved KYLIN-2550.
---------------------------
Resolution: Resolved
> 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)
