drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF GitHub Bot (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-451) JSON read fails if rows have different number of fields
Date Sun, 04 May 2014 00:44:16 GMT

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

Mime
View raw message