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)
|