drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chun Chang (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-1443) order by does not sort when select *
Date Wed, 29 Apr 2015 01:24:05 GMT

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

Mime
View raw message