[ https://issues.apache.org/jira/browse/HIVE-24435?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Zoltan Haindrich reassigned HIVE-24435: --------------------------------------- > Vectorized unix_timestamp is inconsistent with non-vectorized counterpart > ------------------------------------------------------------------------- > > Key: HIVE-24435 > URL: https://issues.apache.org/jira/browse/HIVE-24435 > Project: Hive > Issue Type: Bug > Reporter: Zoltan Haindrich > Assignee: Zoltan Haindrich > Priority: Major > > {code} > create table t (d string); > insert into t values('2020-11-16 22:18:40 UTC'); > select > '>' || d || '<' , unix_timestamp(d), from_unixtime(unix_timestamp(d)), > to_date(from_unixtime(unix_timestamp(d))) > from t > ; > set hive.fetch.task.conversion=none; > select > '>' || d || '<' , unix_timestamp(d), from_unixtime(unix_timestamp(d)), > to_date(from_unixtime(unix_timestamp(d))) > from t > ; > {code} > results: > {code} > -- std udf: > >2020-11-16 22:18:40 UTC< 1605593920 2020-11-16 22:18:40 > >2020-11-16 > -- vectorized udf > >2020-11-16 22:18:40 UTC< NULL NULL NULL > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)