drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-840) CTAS writing nulls as 0s
Date Thu, 31 Jul 2014 05:53:40 GMT

     [ https://issues.apache.org/jira/browse/DRILL-840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jacques Nadeau updated DRILL-840:
---------------------------------

    Fix Version/s:     (was: 0.4.0)
                   0.5.0

> 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: Venki Korukanti
>            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)

Mime
View raw message