[jira] [Created] (DRILL-2186) select * is not working with flatten

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

Rahul Challapalli created DRILL-2186:
----------------------------------------

             Summary: select * is not working with flatten
                 Key: DRILL-2186
                 URL: https://issues.apache.org/jira/browse/DRILL-2186
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
            Reporter: Rahul Challapalli
            Assignee: Daniel Barclay (Drill/MapR)


git.commit.id.abbrev=c54bd6a

Data Set :
{code}
{
  "id" : 1,
  "lst" : [1,2,3]
}
{code}

The below queries incorrectly return null
{code}
0: jdbc:drill:schema=dfs> select *, flatten(lst) from `temp.json`;
+------------+------------+
|     *      |   EXPR$1   |
+------------+------------+
| null       | 1          |
| null       | 2          |
| null       | 3          |
+------------+------------+
{code}

{code}
0: jdbc:drill:schema=dfs> select * from `temp.json` order by flatten(lst);
+------------+
|     *      |
+------------+
| null       |
| null       |
| null       |
+------------+
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)