[
https://issues.apache.org/jira/browse/DRILL-1642?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jason Altekruse resolved DRILL-1642.
------------------------------------
Resolution: Duplicate
> flatten function is dropping the last record when the json file contains even
> no of records
> -------------------------------------------------------------------------------------------
>
> Key: DRILL-1642
> URL: https://issues.apache.org/jira/browse/DRILL-1642
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - JSON
> Reporter: Rahul Challapalli
> Assignee: Jason Altekruse
> Attachments: flatten.json
>
>
> git.commit.id.abbrev=5adadfa
> The below query does not produce the right output. It is missing the last
> record from the data file. The record count is even for the data set. However
> if it is odd, the flatten operator has not issues .
> {code}
> 0: jdbc:drill:schema=dfs> select rownum, flatten(complex) from `flatten.json`;
> +------------+------------+
> | rownum | EXPR$1 |
> +------------+------------+
> | 1 | {"col1":3} |
> | 1 | {"col2":2,"col3":1} |
> | 1 | {"col1":7} |
> | 2 | {"col2":2,"col3":1} |
> | 2 | {"col1":7} |
> | 3 | {"col1":2,"col3":1} |
> +------------+------------+
> {code}
> Attached the data file. Let me know if you need anything more.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
