hive-dev mailing list archives

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


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:
>             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

View raw message