Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.0.1
-
Untriaged
-
Unknown
-
CX Sprint 145
Description
The query
SELECT 100 * (multiple_address / total) AS m_adrr_pct
|
FROM (SELECT
|
count(*) AS total,
|
SUM(CASE WHEN ARRAY_COUNT(address) > 1 THEN 1 ELSE 0 END) AS multiple_address,
|
SUM(CASE WHEN (SOME a IN address SATISFIES a LIKE '%Street%' END) THEN 1 ELSE 0 END) AS addr_str
|
FROM breweries) AS brew_summaries;
|
returns an Internal error.
The logs contain this stack trace
2019-04-01T08:50:59.560-07:00 ERRO CBAS.apache.asterix [Executor-2:ClusterController] Unexpected exception
|
java.lang.IllegalStateException: []:[$a]
|
at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:190) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:93) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:57) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:194) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:308) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppSimpleExpressionVisitor.visit(AbstractSqlppSimpleExpressionVisitor.java:359) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:105) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.clause.FromTerm.accept(FromTerm.java:51) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:92) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.clause.FromClause.accept(FromClause.java:40) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:105) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.rewrites.visitor.SqlppGroupByAggregationSugarVisitor.visit(SqlppGroupByAggregationSugarVisitor.java:93) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.struct.SetOperationInput.accept(SetOperationInput.java:57) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:194) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.clause.SelectSetOperation.accept(SelectSetOperation.java:47) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:308) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.expression.SelectExpression.accept(SelectExpression.java:55) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppSimpleExpressionVisitor.visit(AbstractSqlppSimpleExpressionVisitor.java:359) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:214) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.visitor.base.AbstractSqlppExpressionScopingVisitor.visit(AbstractSqlppExpressionScopingVisitor.java:59) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.common.statement.Query.accept(Query.java:94) ~[asterix-lang-common.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewriteGroupByAggregationSugar(SqlppQueryRewriter.java:151) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.lang.sqlpp.rewrites.SqlppQueryRewriter.rewrite(SqlppQueryRewriter.java:122) ~[asterix-lang-sqlpp.jar:6.0.1-2037]
|
at org.apache.asterix.api.common.APIFramework.reWriteQuery(APIFramework.java:191) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.translator.QueryTranslator.rewriteCompileQuery(QueryTranslator.java:1989) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.translator.QueryTranslator.lambda$handleQuery$30(QueryTranslator.java:2500) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.translator.QueryTranslator.createAndRunJob(QueryTranslator.java:2625) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.translator.QueryTranslator.deliverResult(QueryTranslator.java:2544) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.translator.QueryTranslator.handleQuery(QueryTranslator.java:2513) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:393) ~[asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:136) [asterix-app.jar:6.0.1-2037]
|
at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:66) [asterix-app.jar:6.0.1-2037]
|
at org.apache.hyracks.control.cc.work.ApplicationMessageWork$1.run(ApplicationMessageWork.java:55) [hyracks-control-cc.jar:6.0.1-2037]
|
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
|
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
|
at java.lang.Thread.run(Thread.java:834) [?:?]
|
Attachments
Issue Links
- links to