[
https://issues.apache.org/jira/browse/HIVE-3386?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lefty Leverenz resolved HIVE-3386.
----------------------------------
Resolution: Fixed
Changed in the wikidoc.
> Document how to import NULL values into a table at LanguageManual+Types (\N
> with Lazy SerDe)
> --------------------------------------------------------------------------------------------
>
> Key: HIVE-3386
> URL: https://issues.apache.org/jira/browse/HIVE-3386
> Project: Hive
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 0.9.0
> Reporter: Jakub Holy
> Assignee: Lefty Leverenz
>
> 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).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
