Jakub Holy created HIVE-3386:
--------------------------------
Summary: 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
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
