Details
-
Bug
-
Resolution: Fixed
-
Major
-
Columnar 1.0.0
-
Untriaged
-
0
-
Unknown
-
Analytics Sprint 47, Analytics Sprint 48
Description
The following query fails with internal error
SELECT ht.name, ht.phone,
|
ARRAY_COUNT(ht.reviews) AS num_reviews,
|
(select value MIN(ratings.Overall) from ht.reviews)[0] AS overall_avg,
|
(select value ratings.Overall from ht.reviews) as overall_reviews
|
FROM hotel ht
|
WHERE ht.city = 'Los Angeles'
|
ORDER BY overall_avg DESC
|
limit 5;
|
Following exception can be seen in the logs
n_0:2024-07-25T12:03:11.315-07:00 WARN CBAS.server.QueryServiceServlet [HttpExecutor(port:9600)-1] handleException: unexpected exception: uuid=c1dbafa5-4b26-4aac-a6f5-04daf27ba48f, clientContextID=c01032e3-c49b-4eee-817d-baf4d756110e
|
n_0:java.lang.IllegalStateException: Cannot replace OBJECT with ANY
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.schema.ObjectExpectedSchemaNode.replaceChild(ObjectExpectedSchemaNode.java:70) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.schema.ExpectedSchemaBuilder.handleObject(ExpectedSchemaBuilder.java:205) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.schema.ExpectedSchemaBuilder.addOrReplaceChild(ExpectedSchemaBuilder.java:174) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.schema.ExpectedSchemaBuilder.setSchemaFromExpression(ExpectedSchemaBuilder.java:64) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.visitor.ExpressionValueAccessPushdownVisitor.isSuccessfullyPushedDown(ExpressionValueAccessPushdownVisitor.java:122) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.visitor.ExpressionValueAccessPushdownVisitor.transform(ExpressionValueAccessPushdownVisitor.java:52) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.processor.ColumnValueAccessPushdownProcessor.pushdownFieldAccess(ColumnValueAccessPushdownProcessor.java:97) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.processor.ColumnValueAccessPushdownProcessor.pushdownFieldAccess(ColumnValueAccessPushdownProcessor.java:109) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.processor.ColumnValueAccessPushdownProcessor.pushdownFieldAccess(ColumnValueAccessPushdownProcessor.java:109) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.processor.ColumnValueAccessPushdownProcessor.pushdownFieldAccessForDataset(ColumnValueAccessPushdownProcessor.java:81) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.processor.ColumnValueAccessPushdownProcessor.process(ColumnValueAccessPushdownProcessor.java:62) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.pushdown.PushdownProcessorsExecutor.execute(PushdownProcessorsExecutor.java:63) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.optimizer.rules.PushValueAccessAndFilterDownRule.rewritePre(PushValueAccessAndFilterDownRule.java:102) ~[asterix-algebra.jar:1.0.0-0000]
|
n_0: at org.apache.hyracks.algebricks.core.rewriter.base.AbstractRuleController.rewriteOperatorRef(AbstractRuleController.java:79) ~[algebricks-core.jar:1.0.0-0000]
|
n_0: at org.apache.hyracks.algebricks.compiler.rewriter.rulecontrollers.SequentialOnceRuleController.rewriteWithRuleCollection(SequentialOnceRuleController.java:43) ~[algebricks-compiler.jar:1.0.0-0000]
|
n_0: at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runOptimizationSets(HeuristicOptimizer.java:92) ~[algebricks-core.jar:1.0.0-0000]
|
n_0: at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.runPhysicalOptimizationSets(HeuristicOptimizer.java:122) ~[algebricks-core.jar:1.0.0-0000]
|
n_0: at org.apache.hyracks.algebricks.core.rewriter.base.HeuristicOptimizer.optimize(HeuristicOptimizer.java:66) ~[algebricks-core.jar:1.0.0-0000]
|
n_0: at org.apache.hyracks.algebricks.compiler.api.HeuristicCompilerFactoryBuilder$CompilerImpl.optimize(HeuristicCompilerFactoryBuilder.java:165) ~[algebricks-compiler.jar:1.0.0-0000]
|
n_0: at org.apache.asterix.api.common.APIFramework.compileQuery(APIFramework.java:289) ~[asterix-app.jar:1.0.0-0000]
|