You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2015/04/29 03:24:05 UTC
[jira] [Closed] (DRILL-1443) order by does not sort when select *
[ https://issues.apache.org/jira/browse/DRILL-1443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chun Chang closed DRILL-1443.
-----------------------------
Assignee: Chun Chang (was: Jinfeng Ni)
verified fix and added a new test case - Functional/Passing/orderby/orderby16.q
> 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
> Assignee: Chun Chang
> Fix For: 0.6.0
>
>
> 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)