[
https://issues.apache.org/jira/browse/HIVE-16418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15968551#comment-15968551
]
Rui Li commented on HIVE-16418:
-------------------------------
Thanks guys for your inputs!
To [~gopalv]'s question:
bq. That's the part that confuses me, what are in these bytes?
These bytes are the timezone info (offset from GMT) of each TimestampTZ field.
The reason why I wanted to store the TZ info is to solve HIVE-14305. UDFs
{{to_utc_timestamp}} and {{from_utc_timestamp}} essentially require the
TimestampTZ data type. But if we don't store TZ part, the timestamp will
display using the default TZ. But the default TZ may skip some timestamp due to
DST, and thus gives wrong result.
I'm not sure how to solve the issue w/o storing TZ. Any suggestions?
> Allow HiveKey to skip some bytes for comparison
> -----------------------------------------------
>
> Key: HIVE-16418
> URL: https://issues.apache.org/jira/browse/HIVE-16418
> Project: Hive
> Issue Type: New Feature
> Reporter: Rui Li
> Assignee: Rui Li
> Attachments: HIVE-16418.1.patch
>
>
> The feature is required when we have to serialize some fields and prevent
> them from being used in comparison, e.g. HIVE-14412.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
