[jira] [Created] (DRILL-840) CTAS writing nulls as 0s

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

Ramana Inukonda Nagaraj created DRILL-840:
---------------------------------------------

             Summary: CTAS writing nulls as 0s
                 Key: DRILL-840
                 URL: https://issues.apache.org/jira/browse/DRILL-840
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Writer
            Reporter: Ramana Inukonda Nagaraj


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





--
This message was sent by Atlassian JIRA
(v6.2#6252)