calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Julian Hyde (Jira)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-3286) In LatticeSuggester, allow join conditions that use expressions
Date Fri, 23 Aug 2019 04:01:00 GMT
Julian Hyde created CALCITE-3286:
------------------------------------

             Summary: In LatticeSuggester, allow join conditions that use expressions
                 Key: CALCITE-3286
                 URL: https://issues.apache.org/jira/browse/CALCITE-3286
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde


In {{LatticeSuggester}}, allow join conditions that use expressions. For example, the query
{code}
select *
from emp
join dept on emp.deptno + 1 = dept.deptno
{code}
uses an expression "emp.deptno + 1" on the "emp" side of the join key.

Currently this query throws:
{noformat}
java.lang.ClassCastException: class org.apache.calcite.materialize.LatticeSuggester$DerivedColRef
cannot be cast to class org.apache.calcite.materialize.LatticeSuggester$BaseColRef
	at org.apache.calcite.materialize.LatticeSuggester.frame(LatticeSuggester.java:478)
	at org.apache.calcite.materialize.LatticeSuggester.frame(LatticeSuggester.java:420)
	at org.apache.calcite.materialize.LatticeSuggester.frame(LatticeSuggester.java:399)
	at org.apache.calcite.materialize.LatticeSuggester.addQuery(LatticeSuggester.java:124)
{noformat}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

Mime
View raw message