You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "lianle987 (JIRA)" <ji...@apache.org> on 2018/11/25 09:22:00 UTC

[jira] [Created] (KYLIN-3701) non-ANSI join syntax support

lianle987 created KYLIN-3701:
--------------------------------

             Summary: non-ANSI join syntax support
                 Key: KYLIN-3701
                 URL: https://issues.apache.org/jira/browse/KYLIN-3701
             Project: Kylin
          Issue Type: Improvement
    Affects Versions: v2.5.0
            Reporter: lianle987


the non-ANSI join syntax is popular,such as Oracle,MySQL,Hive,Greeplumn also support it.

And  BI tool such as OBIEE generate non-ANSI join syntax SQL,so If we want to make OBIEE works with Kylin ，Kylin should support non-ANSI join syntax.

for example:


select sum(T814758.PRICE) as c1,
     T814769.YEAR_BEG_DT as c2
from 
     KYLIN_CAL_DT T814769,
     KYLIN_SALES T814758
where  ( T814758.PART_DT = T814769.CAL_DT ) 
group by T814769.YEAR_BEG_DT

 

doesn't work with Kylin.

 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)