[jira] [Commented] (KYLIN-2550) Error while executing SQL query on Kylin 2.0 Beta version

["liyang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-2550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15970763#comment-15970763 ] 

liyang commented on KYLIN-2550:
-------------------------------

Need more info to pin down the root cause. Could you provide a diagnosis pack?

http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/

Also beta2 has fixed many query bugs, may you try again on beta2?

http://kylin.apache.org/download/

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