drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-1062) DRILL does not handle NULLS FIRST/LAST correctly in ORDER BY clause
Date Tue, 24 Jun 2014 21:08:26 GMT
Jinfeng Ni created DRILL-1062:
---------------------------------

             Summary: DRILL does not handle NULLS FIRST/LAST correctly in ORDER BY clause
                 Key: DRILL-1062
                 URL: https://issues.apache.org/jira/browse/DRILL-1062
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Jinfeng Ni
            Assignee: Jinfeng Ni


ORDER BY clause could specify nulls first or nulls last.  Currently, DRILL will always use
nulls last policy. 

select tbl.topping[3].type from dfs.`/Users/jni/work/incubator-drill/exec/ref/target/test-classes/donuts.json`
as tbl order by 1 nulls last;
+------------+
|   EXPR$0   |
+------------+
| Chocolate  |
| Maple      |
| Powdered Sugar |
| Powdered Sugar |
| null       |
+------------+
5 rows selected (0.156 seconds)
0: jdbc:drill:zk=local> select tbl.topping[3].type from dfs.`/Users/jni/work/incubator-drill/exec/ref/target/test-classes/donuts.json`
as tbl order by 1 nulls first;
+------------+
|   EXPR$0   |
+------------+
| Chocolate  |
| Maple      |
| Powdered Sugar |
| Powdered Sugar |
| null       |
+------------+
5 rows selected (0.186 seconds)




--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message