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

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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)