Repository navigation
Milestone
Description
Reproducible on current master with HiveQueryRunner, so affects 374 too (and maybe all versions since #7994, i.e. 372+)
trino:tpch> CREATE TABLE t(r row(a varchar, b int));
CREATE TABLE
trino:tpch> SET SESSION iterative_optimizer_timeout = '10s';
SET SESSION
trino:tpch> SELECT r, r.a LIKE 'a%' FROM t;
Query 20220318_092354_00036_63qnj failed: The optimizer exhausted the time limit of 10000 ms: Top rules: {
io.trino.sql.planner.iterative.rule.PushProjectionIntoTableScan@46d83ec4: 3652 ms, 39605 invocations, 39605 applications,
io.trino.sql.planner.iterative.rule.PruneTableScanColumns@c651286: 1404 ms, 39605 invocations, 39604 applications,
io.trino.sql.planner.iterative.rule.PushProjectionThroughUnion@78de0f6f: 192 ms, 39605 invocations, 0 applications,
io.trino.sql.planner.iterative.rule.RemoveRedundantIdentityProjections@2ccb8db3: 150 ms, 39605 invocations, 0 applications,
io.trino.sql.planner.iterative.rule.PushProjectionThroughExchange@588614f9: 132 ms, 39605 invocations, 0 applications }
io.trino.spi.TrinoException: The optimizer exhausted the time limit of 10000 ms: Top rules: {
io.trino.sql.planner.iterative.rule.PushProjectionIntoTableScan@46d83ec4: 3652 ms, 39605 invocations, 39605 applications,
io.trino.sql.planner.iterative.rule.PruneTableScanColumns@c651286: 1404 ms, 39605 invocations, 39604 applications,
io.trino.sql.planner.iterative.rule.PushProjectionThroughUnion@78de0f6f: 192 ms, 39605 invocations, 0 applications,
io.trino.sql.planner.iterative.rule.RemoveRedundantIdentityProjections@2ccb8db3: 150 ms, 39605 invocations, 0 applications,
io.trino.sql.planner.iterative.rule.PushProjectionThroughExchange@588614f9: 132 ms, 39605 invocations, 0 applications }
at io.trino.sql.planner.iterative.IterativeOptimizer$Context.checkTimeoutNotExhausted(IterativeOptimizer.java:376)
at io.trino.sql.planner.iterative.IterativeOptimizer.exploreNode(IterativeOptimizer.java:156)
at io.trino.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:132)
at io.trino.sql.planner.iterative.IterativeOptimizer.exploreChildren(IterativeOptimizer.java:251)
at io.trino.sql.planner.iterative.IterativeOptimizer.exploreGroup(IterativeOptimizer.java:134)
at io.trino.sql.planner.iterative.IterativeOptimizer.optimize(IterativeOptimizer.java:117)
at io.trino.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:238)
at io.trino.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:215)
at io.trino.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:210)
at io.trino.execution.SqlQueryExecution.doPlanQuery(SqlQueryExecution.java:473)
at io.trino.execution.SqlQueryExecution.planQuery(SqlQueryExecution.java:454)
at io.trino.execution.SqlQueryExecution.start(SqlQueryExecution.java:395)
at io.trino.execution.SqlQueryManager.createQuery(SqlQueryManager.java:243)
at io.trino.dispatcher.LocalDispatchQuery.lambda$startExecution$7(LocalDispatchQuery.java:143)
at io.trino.$gen.Trino_testversion____20220318_092222_3.run(Unknown Source)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:829)
cc @martint @wendigo @hashhar @assaf2 @losipiuk
Rel: #11560
Activity
findepi commentedon Mar 18, 2022
Note that disabling
complex_expression_pushdownis not a workaround:findepi commentedon Mar 18, 2022
cc @alexjo2144 @phd3
findepi commentedon Mar 18, 2022
Repro: #11561