[
https://issues.apache.org/jira/browse/HIVE-6316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14018154#comment-14018154
]
Eugene Koifman commented on HIVE-6316:
--------------------------------------
[~leftylev],
w.r.t. HCatLoader/Storer - tinyint and smallint Hive types support was there
prior to 0.13. (Though perhaps that was not documented).
altogether support for 5 new types was added (both HCatLoader/Storer and
HCatInput/OutputFormat): date, timestamp, char, varchar, decimal.
If you look at 1st column of
https://issues.apache.org/jira/secure/attachment/12626251/HCat-Pig%20Type%20Mapping%20Hive%200.13.pdf,
it lists <type name>/<java class/primitive>. The Java class/primitive is what
the user can expect in HCatRecord produced by using HCatInputFormat and what
they should use in HCatRecord to write it with HCatOutputFormat. The only
omission in the PDF doc is that DATE maps to java.sql.Date.
Thus in
https://cwiki.apache.org/confluence/display/Hive/HCatalog+InputOutput#HCatalogInputOutput-HCatRecord,
these 5 types should be added to the table. (DECIMAL is already there, but was
not supported until 0.13 and it maps to HiveDecimal Java class)
The range of values for primitive types is what is dictated by Java, and for
Object types, users could look at the JavaDoc for corresponding Java classes.
> Document support for new types in HCat
> --------------------------------------
>
> Key: HIVE-6316
> URL: https://issues.apache.org/jira/browse/HIVE-6316
> Project: Hive
> Issue Type: Sub-task
> Components: Documentation, HCatalog
> Affects Versions: 0.13.0
> Reporter: Eugene Koifman
> Assignee: Lefty Leverenz
>
> HIVE-5814 added support for new types in HCat. The PDF file in that bug
> explains exactly how these map to Pig types. This should be added to the
> Wiki somewhere (probably here
> https://cwiki.apache.org/confluence/display/Hive/HCatalog+LoadStore).
> In particular it should be highlighted that copying data from Hive TIMESTAMP
> to Pig DATETIME, any 'nanos' in the timestamp will be lost. Also, HCatStorer
> now takes new parameter which is described in the PDF doc.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
