Khurram Faraaz created DRILL-2987:
-------------------------------------
Summary: 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
Assignee: Jinfeng Ni
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)
