drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Barclay (Drill/MapR) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2036) select * query returns wrong result when column name in json file changes case
Date Tue, 20 Jan 2015 00:21:34 GMT

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

Daniel Barclay (Drill/MapR) commented on DRILL-2036:
----------------------------------------------------

And what is the reported column name supposed to be?  (The first capitalization seen?  The
last capitalization seen?  Any capitalization seen in the source?  Or something else (e.g,
all lowercase, all uppercase)?)

> select * query returns wrong result when column name in json file changes case
> ------------------------------------------------------------------------------
>
>                 Key: DRILL-2036
>                 URL: https://issues.apache.org/jira/browse/DRILL-2036
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - JSON
>    Affects Versions: 0.8.0
>            Reporter: Victoria Markman
>            Assignee: Hanifi Gunes
>            Priority: Critical
>
> {code}
> #Sun Jan 18 21:24:57 EST 2015
> git.commit.id.abbrev=a418af1
> {code}
> test.json - column "city" has upper case C in the second row
> {code}
> { "CustomerId": "100", "city": 10 }
> { "CustomerId": "101", "City": 20 }
> {code}
> Wrong result:
> {code}
> 0: jdbc:drill:schema=dfs> select * from `test.json`;
> +------------+------------+
> | CustomerId |    city    |
> +------------+------------+
> | 100        | null       |
> | 101        | 20         |
> +------------+------------+
> 2 rows selected (0.077 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message