[DRILL-409] JSON Column names such as first ,last not returning data- NULL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Unassigned
• Reporter: Ramana Inukonda Nagaraj
• Created: 10/Mar/14 21:26
• Updated: 31/Jul/14 06:32
• Resolved: 29/Mar/14 18:25

Description

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.