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

Posted to issues@kylin.apache.org by "Roger Shi (JIRA)" <ji...@apache.org> on 2017/08/03 07:27:00 UTC

[jira] [Created] (KYLIN-2777) Should throw error when sql contains non-equi left join

Roger Shi created KYLIN-2777:
--------------------------------

             Summary: Should throw error when sql contains non-equi left join
                 Key: KYLIN-2777
                 URL: https://issues.apache.org/jira/browse/KYLIN-2777
             Project: Kylin
          Issue Type: Bug
            Reporter: Roger Shi


SQL like:

select fact_table.A, lookup_table.B
from fact_table fa left join lookup_table lo
on fa.C = lo.D and fa.E = 'asdf'

The join is non-equi left join. It's not support in Kylin data model, should throw error instead of ignore it. Current implementation leads to wrong result instead of clear error message.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)