[jira] [Resolved] (DRILL-2186) select * is not working with flatten

["Sean Hsuan-Yi Chu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2186?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sean Hsuan-Yi Chu resolved DRILL-2186.
--------------------------------------
    Resolution: Duplicate

> 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)