[jira] [Commented] (DRILL-2217) Trying to flatten an empty list should return an empty result

["Ian Hellstrom (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-2217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15192830#comment-15192830 ] 

Ian Hellstrom commented on DRILL-2217:
--------------------------------------

What is the status of this issue? 

It is hard to believe that support for JSON stops at empty arrays. Drill does proclaim that it 'features a JSON data model that enables queries on complex/nested data as well as rapidly evolving structures ...'. 

It is vital that a) no exceptions are thrown when empty arrays are encountered, and b) it is possible to return the outer bits of a nested data structure even when the array itself is empty. The latter is similar to Hive's LATERAL VIEW OUTER syntax.

> 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
>             Fix For: Future
>
>         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)