[
https://issues.apache.org/jira/browse/HIVE-16418?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15967307#comment-15967307
]
Gopal V edited comment on HIVE-16418 at 4/13/17 8:57 AM:
---------------------------------------------------------
Please explain the behaviour of TimestampTZ when it comes to equality across
all operators - is the same UTC timestamp from different timezones equal or not?
If I have two rows with
TimestampTZ('2005-04-03 10:01:00','Asia/Shanghai')
TimestampTZ('2005-04-03 10:01:00 GMT+08:00')
What is the output of count(distinct tzcol)?
What is the output of select distinct tzcol from table?
What will be the output of select max(tzcol), min(tzcol) from table?
Ordering fixes need to come after working out equality conditions when it comes
to group-by, distinct, joins and over() partitions (some of those are driven by
hash equality as well).
This feature has to be -1, if it does not actually handle all these logical
operations consistently in all execution engines.
was (Author: gopalv):
Please explain the behaviour of TimestampTZ when it comes to equality across
all operators - is the same UTC timestamp from different timezones equal or not?
If I have two rows with
TimestampTZ('2005-04-03 10:01:00','Asia/Shanghai')
TimestampTZ('2005-04-03 10:01:00 GMT+08:00')
What is the output of count(distinct tzcol)?
What is the output of select distinct tzcol from table?
What will be the output of select max(tzcol), min(tzcol) from table?
Ordering fixes need to come after working out equality conditions when it comes
to group-by, distinct, joins and over() partitions (some of those are driven by
hash equality as well).
> 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)
