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)
