[
https://issues.apache.org/jira/browse/DRILL-942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-942.
----------------------------------
Resolution: Won't Fix
Assignee: Jacques Nadeau
As I understand it, SQL server deprecated ordinal positions for ORDER by. This
is also frowned by most SQL writers given the possible confusion. Given the
schemaless nature of Drill, this becomes especially ambiguous so we should
avoid supporting this.
> 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
> Assignee: Jacques Nadeau
> 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)
