drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1443) order by does not sort when select *
Date Mon, 22 Sep 2014 23:44:35 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14144050#comment-14144050
] 

Mehant Baid commented on DRILL-1443:
------------------------------------

This is a planning issue, external sort operator seems to be sorting on the expression '*'
instead of the column name. 

> 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: Jinfeng Ni
>
> 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