[
https://issues.apache.org/jira/browse/DRILL-840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mehant Baid resolved DRILL-840.
-------------------------------
Resolution: Fixed
Works as expected on the latest master: 98b208e262dd9b54988f5eeffacea7d0e83c958c
> 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
> Assignee: Mehant Baid
> Priority: Critical
> Fix For: 0.5.0
>
>
> 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)
