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)
