Zhiyong Liu created DRILL-1443:
----------------------------------
Summary: order by does not sort when select *
Key: DRILL-1443
URL: https://issues.apache.org/jira/browse/DRILL-1443
Project: Apache Drill
Issue Type: Bug
Components: Functions - Drill
Reporter: Zhiyong Liu
git.commit.id.abbrev=f8d38b6
git.commit.id=f8d38b64e6e19367da22f5e65fde01f050102296
0: jdbc:drill:schema=dfs.Tpch-Multi> select * from region;
+-------------+------------+------------+
| R_REGIONKEY | R_NAME | R_COMMENT |
+-------------+------------+------------+
| 2 | [B@7c7d3eb3 | [B@29f999f |
| 3 | [B@3c1e9711 | [B@7c4ffbec |
| 4 | [B@4cfbc929 | [B@2653ca3b |
| 0 | [B@530f5e8e | [B@1608e73c |
| 1 | [B@22851f71 | [B@51d3456b |
+-------------+------------+------------+
5 rows selected (0.184 seconds)
0: jdbc:drill:schema=dfs.Tpch-Multi> select * from region order by R_REGIONKEY;
+-------------+------------+------------+
| R_REGIONKEY | R_NAME | R_COMMENT |
+-------------+------------+------------+
| 2 | [B@1fb66e87 | [B@2127155 |
| 3 | [B@8ce8483 | [B@2e5db8f9 |
| 4 | [B@1862dd93 | [B@2c0ea67 |
| 0 | [B@475d119a | [B@2f2eba10 |
| 1 | [B@10b9982b | [B@8b537a1 |
+-------------+------------+------------+
5 rows selected (0.149 seconds)
Compare:
0: jdbc:drill:schema=dfs.Tpch-Multi> select R_REGIONKEY, R_NAME, R_COMMENT from
region order by R_REGIONKEY;
+-------------+------------+------------+
| R_REGIONKEY | R_NAME | R_COMMENT |
+-------------+------------+------------+
| 0 | [B@6dfbc89a | [B@2d2f2edf |
| 1 | [B@5e652b7b | [B@4409c8a7 |
| 2 | [B@5e546ed6 | [B@7938d3fb |
| 3 | [B@1e541ea | [B@724a6a9e |
| 4 | [B@352c11d | [B@2e04589f |
+-------------+------------+------------+
5 rows selected (0.167 seconds)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
