[
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)