[ https://issues.apache.org/jira/browse/HIVE-1466?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13850110#comment-13850110 ]
Prasad Mujumdar commented on HIVE-1466: --------------------------------------- [~thejas] Thanks for pointing that out. I just updated the wiki to reflect the syntax changes. will add a rel note on the ticket. I guess it's a good idea to have a doc jira along with the a patch that introduces a user facing change (SQL syntax, script/tools etc). The reviewers should also verify that before approving the patch. > 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 > Reporter: Adam Kramer > Assignee: Prasad Mujumdar > 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)