[ https://issues.apache.org/jira/browse/HIVE-8052?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14142748#comment-14142748 ]
Matt McCline commented on HIVE-8052: ------------------------------------ Yes, good point. Added variance, var_pop, var_samp, std, stddev, stddev_pop, stddev_samp. It turns out sum(timestamp) is planned with a Double as output from the aggregation instead of BigInt and this doesn't work when the reduce-side is vectorized. So, it remains unvectorized (see HIVE-8211). > Vectorization: min() on TimeStamp datatype fails with error "Vector aggregate > not implemented: min for type: TIMESTAMP" > ----------------------------------------------------------------------------------------------------------------------- > > Key: HIVE-8052 > URL: https://issues.apache.org/jira/browse/HIVE-8052 > Project: Hive > Issue Type: Bug > Reporter: Matt McCline > Assignee: Matt McCline > Priority: Critical > Attachments: HIVE-8052.01.patch, HIVE-8052.02.patch, > HIVE-8052.04.patch, HIVE-8052.05.patch > > > Changes in HIVE-5760 to make explicit when timestamp and date can be > vectorized as Long were accidentally to strict for min, max, count, etc. -- This message was sent by Atlassian JIRA (v6.3.4#6332)