You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Victoria Markman (JIRA)" <ji...@apache.org> on 2015/01/19 20:05:34 UTC
[jira] [Created] (DRILL-2036) select * query returns wrong result
when column name in json file changes case
Victoria Markman created DRILL-2036:
---------------------------------------
Summary: 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
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)