Michael Smith has posted comments on this change. ( 
http://gerrit.cloudera.org:8080/22092 )

Change subject: IMPALA-13531: (Addendum) CALCITE-5207 workaround
......................................................................


Patch Set 10:

> Patch Set 10:
>
> > Patch Set 10:
> >
> > Do you remember the example that caused this issue?
> >
> > Looking at the code, it looks like something like this would cause the 
> > problem?
> >
> > select interval 4 months + timestamp_col from functional.alltypestiny;
> >
> > But this seems to work fine now.  I'm wondering if this problem was fixed 
> > in a different way along the way.
> >
> > If it is still a problem with different SQL, perhaps we can add it to 
> > calcite.test
>
> It's TPC-DS q5. I'll try to clean it up into a smaller example.

Specific error is

RuntimeException: Error while applying rule MaterializedViewJoinRule(Filter), 
args 
[rel#1211:LogicalFilter.NONE(input=RelSubset#1210,condition=AND(>=(CAST($1):DATE,
 EXPLICIT_CAST(_UTF-8'1998-08-04':VARCHAR(2147483647) CHARACTER SET "UTF-8")), 
<=(CAST($1):DATE, +(EXPLICIT_CAST(_UTF-8'1998-08-04':VARCHAR(2147483647) 
CHARACTER SET "UTF-8"), *(14:TINYINT, 86400000:INTERVAL DAY)))))]
CAUSED BY: ClassCastException: class org.apache.calcite.sql.type.BasicSqlType 
cannot be cast to class org.apache.calcite.sql.type.IntervalSqlType 
(org.apache.calcite.sql.type.BasicSqlType and 
org.apache.calcite.sql.type.IntervalSqlType are in unnamed module of loader 
'app')


--
To view, visit http://gerrit.cloudera.org:8080/22092
To unsubscribe, visit http://gerrit.cloudera.org:8080/settings

Gerrit-Project: Impala-ASF
Gerrit-Branch: master
Gerrit-MessageType: comment
Gerrit-Change-Id: I9d19e83a3e2188a33d2d4a68b5afd3d457f4077c
Gerrit-Change-Number: 22092
Gerrit-PatchSet: 10
Gerrit-Owner: Michael Smith <[email protected]>
Gerrit-Reviewer: Impala Public Jenkins <[email protected]>
Gerrit-Reviewer: Joe McDonnell <[email protected]>
Gerrit-Reviewer: Michael Smith <[email protected]>
Gerrit-Reviewer: Steve Carlin <[email protected]>
Gerrit-Comment-Date: Mon, 01 Dec 2025 18:34:46 +0000
Gerrit-HasComments: No

Reply via email to