[
https://issues.apache.org/jira/browse/DRILL-451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13988875#comment-13988875
]
ASF GitHub Bot commented on DRILL-451:
--------------------------------------
Github user jacques-n commented on the pull request:
https://github.com/apache/incubator-drill/pull/35#issuecomment-42120554
please close, this already merged.
> JSON read fails if rows have different number of fields
> -------------------------------------------------------
>
> Key: DRILL-451
> URL: https://issues.apache.org/jira/browse/DRILL-451
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Ramana Inukonda Nagaraj
> Assignee: Steven Phillips
>
> Query:
> 0: jdbc:drill:> select * from dfs.`/user/root/employeeObject.json`;
> Notice the input file has different fields.
> Json file:
> {
> "first": "Jimmy1",
> "age": 29,
> "sex": "M",
> "salary": 6300.10
> }
> {
> "first": "Jimmy",
> "last": "James",
> "age": 29,
> "sex": "M",
> "salary": 6300.10
> }
> {
> "first": "Jimmy",
> "sex": "M",
> "salary": 6300.10
> "wealth":100000
> }
> This works though:
> {
> "first": "Jimmy1",
> "age": 29,
> "sex": "M",
> "salary": 6300.10
> }
> {
> "first": "Jimmy",
> "last": "James",
> "age": 29,
> "sex": "M",
> "mom": "testString",
> "salary": 6300.10
> }
> 0: jdbc:drill:> select * from dfs.`/user/root/employeeObject.json`;
> +------------+------------+------------+------------+------------+------------+
> | first | age | sex | salary | last | mom
> |
> +------------+------------+------------+------------+------------+------------+
> | Jimmy1 | 29 | M | 6300.1 | null | null
> |
> | Jimmy | 29 | M | 6300.1 | James | testString
> |
> +------------+------------+------------+------------+------------+------------+
> After playing around a bit, looks like this only happens if the extra field
> is a float. Works perfectly if extra fields are int or string.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
