You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2017/04/19 07:58:42 UTC
[jira] [Resolved] (KYLIN-2550) Error while executing SQL query on
Kylin 2.0 Beta version
[ 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)