You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chris Westin (JIRA)" <ji...@apache.org> on 2015/04/01 18:43:53 UTC
[jira] [Updated] (DRILL-1478) The order of query results for the
selected fields seems to be different from sqlline vs Web UI
[ https://issues.apache.org/jira/browse/DRILL-1478?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chris Westin updated DRILL-1478:
--------------------------------
Assignee: Sudheesh Katkam (was: Jason Altekruse)
> 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: Sudheesh Katkam
> 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)