kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zhuoran Lyu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (KYLIN-2550) Error while executing SQL query on Kylin 2.0 Beta version
Date Mon, 17 Apr 2017 04:55:42 GMT
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)

Mime
View raw message