You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2020/12/03 11:06:00 UTC
[jira] [Work logged] (HIVE-24435) Vectorized unix_timestamp is
inconsistent with non-vectorized counterpart
[ https://issues.apache.org/jira/browse/HIVE-24435?focusedWorklogId=519551&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-519551 ]
ASF GitHub Bot logged work on HIVE-24435:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 03/Dec/20 11:05
Start Date: 03/Dec/20 11:05
Worklog Time Spent: 10m
Work Description: kgyrtkirk merged pull request #1713:
URL: https://github.com/apache/hive/pull/1713
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Issue Time Tracking
-------------------
Worklog Id: (was: 519551)
Time Spent: 20m (was: 10m)
> 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
> Labels: pull-request-available
> Time Spent: 20m
> Remaining Estimate: 0h
>
> {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)