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/10/13 20:38:05 UTC
[jira] [Commented] (DRILL-2987) Inside an inner query : star should
have been expanded (over CSV data)
[ https://issues.apache.org/jira/browse/DRILL-2987?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14955438#comment-14955438 ]
Khurram Faraaz commented on DRILL-2987:
---------------------------------------
I do not see an AssertionError on Drill 1.2.0
{code}
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: VALIDATION ERROR: From line 1, column 91 to line 1, column 93: Expression 'tmp.*' is not being grouped
[Error Id: 10cdd1b6-fdba-43bc-9dbd-0b2d4483778b on centos-03.qa.lab:31010] (state=,code=0)
{code}
> 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)