[ https://issues.apache.org/jira/browse/DRILL-2106?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mehant Baid updated DRILL-2106: ------------------------------- Attachment: DRILL-2106.patch Minor change to the patch, to apply the rule to the child also. Added another test case. > 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 - Data Types, Execution - Relational Operators > Reporter: Rahul Challapalli > Assignee: Mehant Baid > Priority: Critical > Fix For: 0.9.0 > > Attachments: DRILL-2106.patch, error.log > > > 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)