You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/05/29 19:49:05 UTC
[jira] [Commented] (DRILL-455) Inconsistent order of the fields
between the SQL query and results
[ https://issues.apache.org/jira/browse/DRILL-455?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14012603#comment-14012603 ]
Jacques Nadeau commented on DRILL-455:
--------------------------------------
resolved recently in master
> Inconsistent order of the fields between the SQL query and results
> ------------------------------------------------------------------
>
> Key: DRILL-455
> URL: https://issues.apache.org/jira/browse/DRILL-455
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Neeraja
>
> Performed the following query and expect the results to have the same order of fields specified in query i.e l_returnflag first followed by l_linestatus followed by count(*). Currently the order is not obeyed.
> 0: jdbc:drill:> select l_returnflag,l_linestatus, count(*) from lineitem group by l_returnflag, l_linestatus order by l_returnflag,l_linestatus;
> +------------+--------------+--------------+
> | EXPR$2 | l_returnflag | l_linestatus |
> +------------+--------------+--------------+
> | 147790 | A | F |
> | 3765 | N | F |
> | 0 | N | O |
> | 300716 | N | O |
> | 148301 | R | F |
> +------------+--------------+--------------+
--
This message was sent by Atlassian JIRA
(v6.2#6252)