Ramana Inukonda Nagaraj created DRILL-409:
---------------------------------------------
Summary: JSON Column names such as first ,last not returning data-
NULL
Key: DRILL-409
URL: https://issues.apache.org/jira/browse/DRILL-409
Project: Apache Drill
Issue Type: Bug
Reporter: Ramana Inukonda Nagaraj
Assume the json file has columns/fields like
0: jdbc:drill:schema=dfs> select * from
dfs.`/user/root/employeeNestedObject.json`;
+------------+------------+------------+------------+------------+------------+------------+-----------------+------------------+----------------+
| first | last | age | sex | salary | wealth |
registered | favorites.color | favorites.number | favorites.food |
+------------+------------+------------+------------+------------+------------+------------+-----------------+------------------+----------------+
| John | Doe | 39 | M | 2147483647 | 1.7976931E30
| true | Blue | 13 | Spaghetti |
+------------+------------+------------+------------+------------+------------+------------+-----------------+------------------+----------------+
Querying the 'first' column name returns null. Seems to be a reserved word/
function
0: jdbc:drill:schema=dfs> select first from
dfs.`/user/root/employeeNestedObject.json`;
+------------+
| FIRST |
+------------+
| null |
However if the name is changed to firstName it works fine
0: jdbc:drill:schema=dfs> select firstName from
dfs.`/user/root/employeeNestedObject.json`;
+------------+
| firstName |
+------------+
| John |
+------------+
1 row selected (0.082 seconds)
Same for last.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
