Zoltan Haindrich created HIVE-24435:
---------------------------------------
Summary: 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
{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)
