drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Altekruse (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1478) The order of query results for the selected fields seems to be different from sqlline vs Web UI
Date Fri, 27 Feb 2015 15:20:05 GMT

     [ https://issues.apache.org/jira/browse/DRILL-1478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jason Altekruse updated DRILL-1478:
-----------------------------------
    Fix Version/s:     (was: 0.8.0)
                   0.9.0

> The order of query results for the selected fields seems to be different from sqlline
vs Web UI
> -----------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1478
>                 URL: https://issues.apache.org/jira/browse/DRILL-1478
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - HTTP
>         Environment: I executed a query with aggregation, it seems the order results
is different from  sqlline vs Web UI.
>            Reporter: B Anil Kumar
>            Assignee: Jason Altekruse
>             Fix For: 0.9.0
>
>
> Here the order means selected columns order. For example.
> {noformat}
> 0: jdbc:drill:zk=localhost:2181> select state,city,avg(pop) from mongo.test.`zips`
zipcodes group by state, city limit 5;
> +------------+------------+------------+
> |   state    |    city    |   EXPR$2   |
> +------------+------------+------------+
> | MA         | AGAWAM     | 15338.0    |
> | MA         | CUSHMAN    | 36963.0    |
> | MA         | BARRE      | 4546.0     |
> | MA         | BELCHERTOWN | 10579.0    |
> | MA         | BLANDFORD  | 1240.0     |
> +------------+------------+------------+
> {noformat}
> The above is as expected. But where as for the same above query in Web UI
> {noformat}
> EXPR$2  state  city
> 1,240	MA	BLANDFORD
> 4,546	MA	BARRE
> 10,579	MA	BELCHERTOWN
> 15,338	MA	AGAWAM
> 36,963	MA	CUSHMAN
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message