drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B Anil Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1478) The order of query results seems to be different from sqlline vs Web UI
Date Wed, 01 Oct 2014 04:47:34 GMT
B Anil Kumar created DRILL-1478:
-----------------------------------

             Summary: The order of query results 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


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