[jira] [Created] (DRILL-6233) Flattening an Array column (JSON file) return no rows

["Volodymyr Tkach (JIRA)" <ji...@apache.org>]

Volodymyr Tkach created DRILL-6233:
--------------------------------------

             Summary: Flattening an Array column (JSON file) return no rows
                 Key: DRILL-6233
                 URL: https://issues.apache.org/jira/browse/DRILL-6233
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.13.0
            Reporter: Volodymyr Tkach
            Assignee: Volodymyr Tkach


Flatten  return no rows if array is empty.
{noformat}
flat.json
{
  "x" : 5,
  "y" : "a string",
  "z" : []
}
{noformat}
folowing query returns no results:
{noformat}
0: jdbc:drill:zk=local> select flatten(z) from dfs.tmp.`flat.json`;
+---------+
| EXPR$0  |
+---------+
+---------+
{noformat}
but has to return one row with null for flatten function
{noformat}
+----+-----------+-----+
| x  |     y     |  z  |  EXPR$1 | 
+----+-----------+-----+
| 5  | a string  | [] |  null |
+----+-----------+-----+
{noformat}




--
This message was sent by Atlassian JIRA
(v7.6.3#76005)