drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-455) Inconsistent order of the fields between the SQL query and results
Date Thu, 29 May 2014 17:49:05 GMT

     [ https://issues.apache.org/jira/browse/DRILL-455?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau resolved DRILL-455.
----------------------------------

    Resolution: Fixed

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

Mime
View raw message