[DRILL-840] CTAS writing nulls as 0s

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Storage - Writer
• Assignee: Mehant Baid
• Reporter: Ramana Inukonda Nagaraj
• Created: 27/May/14 01:54
• Updated: 06/Aug/14 23:34
• Resolved: 06/Aug/14 23:34

Description

Steps to repro:

CTAS from a json file with missing fields. Ie null values
Select returns the correct value.
0: jdbc:drill:schema=dfs.drillTestDir> select * from `json_storage/employeeObjectMissingField.json`;
--------------------------------------------------------------+

first

last

age

sex

salary

registered

--------------------------------------------------------------+

Jimmy	James	29	M	6300.1	false
anderson	carr	null	M	6300.1	false

--------------------------------------------------------------+

CREATE TABLE CTAS_jsonmissingfield AS select * from `json_storage/employeeObjectMissingField.json`

select * from CTAS_jsonmissingfield returns

anderson carr 0 M 6300.1 false