Anonymous Coward (816) has posted comments on this change. ( http://gerrit.cloudera.org:8080/21575 )
Change subject: IMPALA-13221: Calcite: Enable tpcds and tpch queries ...................................................................... Patch Set 8: (1 comment) http://gerrit.cloudera.org:8080/#/c/21575/8/java/calcite-planner/src/main/java/org/apache/impala/calcite/rules/ExtractLiteralAgg.java File java/calcite-planner/src/main/java/org/apache/impala/calcite/rules/ExtractLiteralAgg.java: http://gerrit.cloudera.org:8080/#/c/21575/8/java/calcite-planner/src/main/java/org/apache/impala/calcite/rules/ExtractLiteralAgg.java@43 PS8, Line 43: * to check for existence in a subquery. In this case, the Aggregate will do a group > hi, create table lineitem(l_orderkey int, l_linenumber int); create table orders(o_orderkey int); insert into lineitem values(1,4); insert into lineitem values(2,1); insert into lineitem values(3,5); insert into orders values(1); insert into orders values(6); Query: select l_orderkey from lineitem where exists (select * from orders where o_orderkey = l_orderkey) or l_linenumber in (1,2,3) ERROR: AnalysisException: EXISTS/NOT EXISTS subqueries in OR predicates are not supported: EXISTS (SELECT * FROM `default`.orders WHERE o_orderkey = l_orderkey) OR l_linenumber IN (1, 2, 3) Can this SQL query run using Calcite? -- To view, visit http://gerrit.cloudera.org:8080/21575 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: comment Gerrit-Change-Id: I3107d336ac07ecd89530b640165798ec6a574f41 Gerrit-Change-Number: 21575 Gerrit-PatchSet: 8 Gerrit-Owner: Steve Carlin <[email protected]> Gerrit-Reviewer: Aman Sinha <[email protected]> Gerrit-Reviewer: Anonymous Coward (816) Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Joe McDonnell <[email protected]> Gerrit-Reviewer: Michael Smith <[email protected]> Gerrit-Comment-Date: Wed, 09 Oct 2024 14:06:32 +0000 Gerrit-HasComments: Yes
