[
https://issues.apache.org/jira/browse/DRILL-2987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15470533#comment-15470533
]
Khurram Faraaz commented on DRILL-2987:
---------------------------------------
assertion is seen on apache Drill 1.9.0
{noformat}
0: jdbc:drill:schema=dfs.tmp> select count(tmp.columns[0]),
count(tmp.columns[1]), max(cast(tmp.columns[4] as double)), tmp.columns[2] from
(select * from `airports.csv` ) tmp;
Error: SYSTEM ERROR: AssertionError
[Error Id: 8d64ae91-0de5-4ffd-81bc-cc62fccb7097 on centos-01.qa.lab:31010]
(state=,code=0)
{noformat}
> Inside an inner query : star should have been expanded (over CSV data)
> ----------------------------------------------------------------------
>
> Key: DRILL-2987
> URL: https://issues.apache.org/jira/browse/DRILL-2987
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Affects Versions: 1.0.0
> Environment: d12bee05a8f6e974c70d5d2a94176b176d7dba5b
> Reporter: Khurram Faraaz
> Fix For: Future
>
>
> When there is a select * from, in an inner query, I see a message that says
> star should be expanded. Test was executed on 4 node cluster on CentOS.
> {code}
> 0: jdbc:drill:> select count(tmp.columns[0]), count(tmp.columns[1]),
> max(cast(tmp.columns[4] as double)), tmp.columns[2] from (select * from
> `airports.csv` ) tmp;
> Error: SYSTEM ERROR: Unexpected exception during fragment initialization:
> star should have been expanded
> [Error Id: 2ed1a83d-b0d6-43ec-bc7c-a08c3cc59284 on centos-02.qa.lab:31010]
> (state=,code=0)
> {code}
> Stack trace from drillbit.log
> {code}
> 2015-05-07 23:13:51,285 [2ab40e4f-c715-e834-c4bb-a1ad227371a9:foreman] ERROR
> o.a.d.c.e.DrillRuntimeException - SYSTEM ERROR: Unexpected exception during
> fragment initialization: star should have been expanded
> [Error Id: 2ed1a83d-b0d6-43ec-bc7c-a08c3cc59284 on centos-02.qa.lab:31010]
> org.apache.drill.common.exceptions.UserException: SYSTEM ERROR: Unexpected
> exception during fragment initialization: star should have been expanded
> [Error Id: 2ed1a83d-b0d6-43ec-bc7c-a08c3cc59284 on centos-02.qa.lab:31010]
> at
> org.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:465)
> ~[drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman$ForemanResult.close(Foreman.java:635)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:732)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman$StateSwitch.processEvent(Foreman.java:674)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.common.EventProcessor.sendEvent(EventProcessor.java:73)
> [drill-common-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman$StateSwitch.moveToState(Foreman.java:676)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman.moveToState(Foreman.java:777)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:212)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [na:1.7.0_75]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [na:1.7.0_75]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75]
> Caused by: org.apache.drill.exec.work.foreman.ForemanException: Unexpected
> exception during fragment initialization: star should have been expanded
> ... 4 common frames omitted
> Caused by: java.lang.AssertionError: star should have been expanded
> at
> org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:86)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:37)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.SqlIdentifier.accept(SqlIdentifier.java:274)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.util.SqlBasicVisitor$ArgHandlerImpl.visitChild(SqlBasicVisitor.java:119)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.SqlOperator.acceptCall(SqlOperator.java:697)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:144)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:37)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:130)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.util.SqlBasicVisitor$ArgHandlerImpl.visitChild(SqlBasicVisitor.java:119)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.SqlOperator.acceptCall(SqlOperator.java:697)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:144)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AggChecker.visit(AggChecker.java:37)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at org.apache.calcite.sql.SqlCall.accept(SqlCall.java:130)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AggregatingSelectScope.checkAggregateExpr(AggregatingSelectScope.java:227)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3269)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2962)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:837)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:552)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:174)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.calcite.prepare.PlannerImpl.validateAndGetType(PlannerImpl.java:185)
> ~[calcite-core-1.1.0-drill-r3.jar:1.1.0-drill-r3]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:191)
> ~[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:143)
> ~[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:167)
> ~[drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at
> org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:788)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:203)
> [drill-java-exec-1.0.0-SNAPSHOT-rebuffed.jar:1.0.0-SNAPSHOT]
> ... 3 common frames omitted
> {code}
> Total columns in the CSV file used in inner query are,
> {code}
> +------------+
> | columns |
> +------------+
> ["id","ident","type","name","latitude_deg","longitude_deg","elevation_ft","continent","iso_country","iso_region","municipality","scheduled_service","gps_code","iata_code","local_code","home_link","wikipedia_link","keywords"]
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
