drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2186) select * is not working with flatten
Date Mon, 09 Feb 2015 05:15:35 GMT
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)

Mime
View raw message