Hive
  1. Hive
  2. HIVE-1466

Add NULL DEFINED AS to ROW FORMAT specification

    Details

    • Type: New Feature New Feature
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.13.0
    • Component/s: SQL
    • Labels:
      None
    • 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.

      Description

      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.

      1. HIVE-1466.1.patch
        28 kB
        Prasad Mujumdar
      2. HIVE-1466.2.patch
        38 kB
        Prasad Mujumdar

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Prasad Mujumdar
              Reporter:
              Adam Kramer
            • Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development