Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-3386

Document how to import NULL values into a table at LanguageManual+Types (\N with Lazy SerDe)

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.9.0
    • Fix Version/s: None
    • Component/s: Documentation
    • Labels:
      None

      Description

      The documentation at https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Types should be enhanced as follows:

      Handling of NULL values

      Missing values are represented by the special value NULL. To import data with NULL fields, check documentation of the SerDe used by the table. (The default Text Format uses LazySimpleSerDe which interprets the string \N as NULL when importing.)

      Reason:
      It's nearly impossible to find out how to make e.g. a string field to be NULL in hive without lot of googling. This is an important thing and should be documented properly at a clearly visible place (the Data Types page seems to be the most logical place to me though LanguageManual+DML would certainly also be a good place).

        Attachments

          Activity

            People

            • Assignee:
              leftylev Lefty Leverenz
              Reporter:
              malyvelky Jakub Holy
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: