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)

Reply via email to