Rahul Challapalli created DRILL-2106: ----------------------------------------
Summary: Flatten together with order by on a list within a list is causing an error Key: DRILL-2106 URL: https://issues.apache.org/jira/browse/DRILL-2106 Project: Apache Drill Issue Type: Bug Components: Execution - Operators Reporter: Rahul Challapalli Assignee: Mehant Baid Priority: Critical git.commit.id.abbrev=3e33880 Data Set : {code} { "uid" : 1, "lst_lst" : [[1,2,3,4,5],[2,3,4,5,6]] } {code} The below query fails {code} select flatten(lst) from (select uid, flatten(d.lst_lst) lst from `temp4.json` d) s1 order by s1.lst[3]; {code} When we remove the top level flatten the below query works {code} select uid from (select uid, flatten(d.lst_lst) lst from `temp4.json` d) s1 order by s1.lst[3]; {code} Attached the error log -- This message was sent by Atlassian JIRA (v6.3.4#6332)