You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "Neeraja (JIRA)" <ji...@apache.org> on 2014/03/27 00:06:24 UTC

[jira] [Created] (DRILL-455) Inconsistent order of the fields between the SQL query and results

Neeraja created DRILL-455:
-----------------------------

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