[jira] [Commented] (DRILL-940) Failure when trying to sort on column that is not selected

["Steven Phillips (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-940?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14025739#comment-14025739 ] 

Steven Phillips commented on DRILL-940:
---------------------------------------

Here is the simple file I used to reproduce it:

{"a":26270,"b":1524}
{"a":3643,"b":18859}
{"a":13204,"b":11615}
{"a":21926,"b":3291}
{"a":15341,"b":12232}
{"a":22752,"b":3377}
{"a":4601,"b":12767}
{"a":30834,"b":8259}
{"a":15547,"b":14500}
{"a":25432,"b":5594}


These queries all fail:

select a from data order by b;
select a from data order by a, b;
select a, 2*b from data order by a, b;

> Failure when trying to sort on column that is not selected
> ----------------------------------------------------------
>
>                 Key: DRILL-940
>                 URL: https://issues.apache.org/jira/browse/DRILL-940
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Steven Phillips
>
> When running a query where the order by clause includes a column that is not in the selection, we get index out of bounds exception:
> jdbc:drill:zk=local> select a from data order by a, b;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "49cb54dd-00cf-4f44-8f01-979471f32cf7"
> endpoint {
>   address: "localhost"
>   user_port: 31010
>   control_port: 31011
>   data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up Foreman. < AssertionError:[ Internal error: Error while applying rule ExpandConversionRule, args [rel#2061:AbstractConverter.LOGICAL.ANY([]).[0, 1](child=rel#2053:Subset#3.LOGICAL.ANY([]).[],convention=LOGICAL,DrillDistributionTraitDef=ANY([]),sort=[0, 1])] ] < IndexOutOfBoundsException:[ index (1) must be less than size (1) ]"
> ]



--
This message was sent by Atlassian JIRA
(v6.2#6252)