[ https://issues.apache.org/jira/browse/DRILL-1062?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Parth Chandra resolved DRILL-1062. ---------------------------------- Resolution: Fixed Resolved in commit 5efc7e6 > 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 > Components: Functions - Drill > Reporter: Jinfeng Ni > Assignee: Daniel Barclay (Drill) > Fix For: 0.8.0 > > Attachments: DRILL-1062.2.patch, DRILL-1062.3.patch.txt, > DRILL-1062.4.patch.txt > > > 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.3.4#6332)