[
https://issues.apache.org/jira/browse/DRILL-942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-942:
---------------------------------
Component/s: Metadata
> group by doesn't work with column number
> ----------------------------------------
>
> Key: DRILL-942
> URL: https://issues.apache.org/jira/browse/DRILL-942
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Reporter: Vivian Summers
> Priority: Minor
> Fix For: 1.0.0-BETA1
>
>
> 0: jdbc:drill:schema=dfs> select uid, count(*) from test where country='US'
> group by 1;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "a21ec4b8-1090-4075-9725-18e71610561a"
> error_type: 0
> message: "Failure while parsing sql. < ValidationException:[
> org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line
> 1, column 10 ] < EigenbaseContextException:[ From line 1, column 8 to line 1,
> column 10 ] < SqlValidatorException:[ Expression 'uid' is not being grouped ]"
> ]
> org.eigenbase.sql.validate.SqlValidatorException: Expression 'uid' is not
> being grouped
> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
> ~[na:1.7.0_45]
> at
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
> ~[na:1.7.0_45]
> at
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
> ~[na:1.7.0_45]
> at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
> ~[na:1.7.0_45]
> at
> org.eigenbase.resource.Resources$ExInstWithCause.ex(Resources.java:348)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.resource.Resources$ExInst.ex(Resources.java:457)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:671)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:659)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3512)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:103)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.validate.AggChecker.visit(AggChecker.java:31)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlIdentifier.accept(SqlIdentifier.java:222)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.AggregatingSelectScope.checkAggregateExpr(AggregatingSelectScope.java:160)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelectList(SqlValidatorImpl.java:3033)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2772)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:80)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:747)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:736)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:209)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:710)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:426)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> net.hydromatic.optiq.prepare.PlannerImpl.validate(PlannerImpl.java:175)
> ~[optiq-core-0.7-20140513.013236-5.jar:na]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.validateNode(DefaultSqlHandler.java:121)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.handlers.DefaultSqlHandler.getPlan(DefaultSqlHandler.java:106)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> org.apache.drill.exec.planner.sql.DrillSqlWorker.getPlan(DrillSqlWorker.java:129)
>
> ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.runSQL(Foreman.java:313)
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at org.apache.drill.exec.work.foreman.Foreman.run(Foreman.java:167)
> [drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
> [na:1.7.0_45]
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
> [na:1.7.0_45]
> at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
--
This message was sent by Atlassian JIRA
(v6.2#6252)
