[
https://issues.apache.org/jira/browse/DRILL-2217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14745802#comment-14745802
]
Victoria Markman commented on DRILL-2217:
-----------------------------------------
With drill 1.2.0 I see result below and I'm not sure if it is correct ...
{code}
0: jdbc:drill:schema=dfs> select empty from `data1.json`;
+--------------+
| empty |
+--------------+
| [[],[null]] |
| [[],[null]] |
+--------------+
2 rows selected (0.167 seconds)
0: jdbc:drill:schema=dfs> select flatten(empty) from `data1.json`;
+---------+
| EXPR$0 |
+---------+
| null |
| null |
| null |
| null |
+---------+
4 rows selected (0.174 seconds)
{code}
> Trying to flatten an empty list should return an empty result
> -------------------------------------------------------------
>
> Key: DRILL-2217
> URL: https://issues.apache.org/jira/browse/DRILL-2217
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Relational Operators
> Reporter: Rahul Challapalli
> Assignee: Jason Altekruse
> Fix For: 1.3.0
>
> Attachments: error.log
>
>
> git.commit.id.abbrev=3d863b5
> Data Set :
> {code}
> {"empty":[[],[[]]]}
> {code}
> Query :
> {code}
> select flatten(empty) from `data1.json`;
> Query failed: RemoteRpcException: Failure while running fragment.[
> 1b3123d9-92bc-45d5-bef8-b5f1be9def07 on qa-node191.qa.lab:31010 ]
> [ 1b3123d9-92bc-45d5-bef8-b5f1be9def07 on qa-node191.qa.lab:31010 ]
> {code}
> I also attached the error from the logs
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
