[jira] [Resolved] (KYLIN-611) Allow Implicit Joins

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

     [ https://issues.apache.org/jira/browse/KYLIN-611?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luke Han resolved KYLIN-611.
----------------------------
    Resolution: Won't Fix

Depends on Calcite's support for this feature.

> Allow Implicit Joins
> --------------------
>
>                 Key: KYLIN-611
>                 URL: https://issues.apache.org/jira/browse/KYLIN-611
>             Project: Kylin
>          Issue Type: Improvement
>          Components: Query Engine
>    Affects Versions: v0.7.1
>            Reporter: Sébastien Jelsch
>            Assignee: liyang
>             Fix For: v0.7.2
>
>         Attachments: implicit-join-exception.txt
>
>
> Allowing Implicit Joins would be a great improvement since tools like Mondrian use this exclusively.
> Trying to execute this SQL Statement
> {code:sql}
> SELECT *
> FROM sales, products
> WHERE sales.product_id = products.id
> {code}
> results in the following error:
> {noformat}
> [ERROR][com.kylinolap.rest.controller.QueryController.doQuery(QueryController.java:227)] - Exception when execute sql
> java.sql.SQLException: error while executing SQL "SELECT * FROM sales, products WHERE sales.product_id = products.id LIMIT 50000": org.eigenbase.rex.RexLiteral cannot be cast to org.eigenbase.rex.RexCall
> {noformat}
> See attachment for full exception details.
> The error is caused by OLAPJoinRel.implementOLAP(OLAPImplementor implementor):
> {code:java}
> RexCall condition = (RexCall) this.getCondition();
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)