[
https://issues.apache.org/jira/browse/HIVE-1466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14031824#comment-14031824
]
Lefty Leverenz commented on HIVE-1466:
--------------------------------------
[~prasadm] documented this in the DDL and DML wikidocs:
* [DDL: Create Table (row_format) |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-CreateTable]
* [DDL: Row Format, Storage Format, and SerDe |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-RowFormat,StorageFormat,andSerDe]
** [DDL doc diffs for HIVE-1466 |
https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=27362034&selectedPageVersions=72&selectedPageVersions=71]
* [DML: Writing data into the filesystem from queries |
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-Writingdataintothefilesystemfromqueries]
** [DML doc diffs for HIVE-1466 |
https://cwiki.apache.org/confluence/pages/diffpagesbyversion.action?pageId=27362036&selectedPageVersions=21&selectedPageVersions=20]
> 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
> Labels: TODOC13
> 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.2#6252)
