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)
