[DRILL-2106] Flatten together with order by on a list within a list is causing an error

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Execution - Data Types, Execution - Relational Operators
• Assignee: Mehant Baid
• Reporter: Rahul Kumar Challapalli
• Created: 29/Jan/15 01:01
• Updated: 21/Apr/15 21:39
• Resolved: 19/Mar/15 02:47

Description

git.commit.id.abbrev=3e33880

Data Set :

{
  "uid" : 1,
  "lst_lst" : [[1,2,3,4,5],[2,3,4,5,6]]
}

The below query fails

select flatten(lst) from (select uid, flatten(d.lst_lst) lst from `temp4.json` d) s1 order by s1.lst[3];

When we remove the top level flatten the below query works

select uid from (select uid, flatten(d.lst_lst) lst from `temp4.json` d) s1 order by s1.lst[3];

Attached the error log

Issue Links

• is depended upon by: DRILL-2012 Flatten fails when we filter by a non-projected column
• is depended upon by: DRILL-2180 Star is not expanded when being used with flatten
• is depended upon by: DRILL-2146 Flatten Function on two layer deep field fails to plan