hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <>
Subject [jira] [Commented] (HIVE-3386) Document how to import NULL values into a table at LanguageManual+Types (\N with Lazy SerDe)
Date Fri, 17 Aug 2012 11:29:38 GMT


Lefty Leverenz commented on HIVE-3386:

I added the new section verbatim to [Data Types|]
in the wiki but wonder why you used initial capitals for Text Format.

Does this information also belong in "Inserting data into Hive Tables from queries" in [DML|]
as another bullet item in the Notes?  Or should a note just refer to the Types doc "for information
about types and NULL values"?

Does the information also belong in the DDL docs?  Wikidoc [DDL|]
already points to Types from its "Create Table" section, but in the Hive xdocs there's another
DDL doc (misnamed [DML|])
that could include this information in its "Using SerDes" section or just point to the Types
> Document how to import NULL values into a table at LanguageManual+Types (\N with Lazy
> --------------------------------------------------------------------------------------------
>                 Key: HIVE-3386
>                 URL:
>             Project: Hive
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 0.9.0
>            Reporter: Jakub Holy
>            Assignee: Lefty Leverenz
> The documentation at
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:!default.jspa
For more information on JIRA, see:


View raw message