You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/05/08 01:23:04 UTC
[jira] [Created] (DRILL-2987) Inside an inner query : star should
have been expanded (over CSV data)
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)