[
https://issues.apache.org/jira/browse/DRILL-409?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau resolved DRILL-409.
----------------------------------
Resolution: Fixed
Fixed somewhere.
> 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)
