[
https://issues.apache.org/jira/browse/HIVE-8211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14543246#comment-14543246
]
Alexander Pivovarov commented on HIVE-8211:
-------------------------------------------
if timestamp value is converted to number then
int part is seconds
fractional part is milliseconds, microseconds, or nanoseconds (but up to 7
digits (not 9))
e.g.
{code}
select cast(cast('2015-05-14 23:20:34.123456789' as timestamp) as
decimal(32,12));
OK
1431670834.1234567
select cast(cast('2015-05-14 23:20:34.123456789' as timestamp) as double());
OK
1.4316708341234567E9
{code}
> Tez and Vectorization of SUM(timestamp) not vectorized -- can't execute
> correctly because aggregation output is double
> ----------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-8211
> URL: https://issues.apache.org/jira/browse/HIVE-8211
> Project: Hive
> Issue Type: Bug
> Components: Tez, Vectorization
> Reporter: Matt McCline
> Assignee: Matt McCline
>
> Vectorization of SUM(timestamp) is currently turned off because the output of
> aggregation is a double (DoubleColumnVector) and the execution code is
> expecting a long (LongColumnVector).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
