[jira] [Created] (DRILL-1062) DRILL does not handle NULLS FIRST/LAST correctly in ORDER BY clause

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

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)