[jira] [Created] (HIVE-24435) Vectorized unix_timestamp is inconsistent with non-vectorized counterpart

[Zoltan Haindrich (Jira)]

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)