hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Prasad Mujumdar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-1466) Add NULL DEFINED AS to ROW FORMAT specification
Date Tue, 17 Dec 2013 05:05:09 GMT

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

Prasad Mujumdar updated HIVE-1466:
----------------------------------

      Component/s: SQL
    Fix Version/s: 0.13.0
     Release Note: This features enables defining a custom null format for a table via 'create
table' statement. A custom null format can also be specified while exporting data to local
filesystem using 'insert overwrite .. local dir' statement.

> Add NULL DEFINED AS to ROW FORMAT specification
> -----------------------------------------------
>
>                 Key: HIVE-1466
>                 URL: https://issues.apache.org/jira/browse/HIVE-1466
>             Project: Hive
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Adam Kramer
>            Assignee: Prasad Mujumdar
>             Fix For: 0.13.0
>
>         Attachments: HIVE-1466.1.patch, HIVE-1466.2.patch
>
>
> NULL values are passed to transformers as a literal backslash and a literal N. NULL values
are saved when INSERT OVERWRITing LOCAL DIRECTORies as "NULL". This is inconsistent.
> The ROW FORMAT specification of tables should be able to specify the manner in which
a null character is represented. ROW FORMAT NULL DEFINED AS '\N' or '\003' or whatever should
apply to all instances of table export and saving.



--
This message was sent by Atlassian JIRA
(v6.1.4#6159)

Mime
View raw message