[jira] [Commented] (HIVE-17892) Vectorization: Wrong results for vectorized_timestamp_funcs.q

["Matt McCline (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-17892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16376507#comment-16376507 ] 

Matt McCline commented on HIVE-17892:
-------------------------------------

The 4th query has different results for row- vs vector-mode output.
{noformat}
-- Wrong format. Should all be NULL.
SELECT
  to_unix_timestamp(stimestamp1) AS c1,
  year(stimestamp1),
  month(stimestamp1),
  day(stimestamp1),
  dayofmonth(stimestamp1),
  weekofyear(stimestamp1),
  hour(stimestamp1),
  minute(stimestamp1),
  second(stimestamp1)
FROM alltypesorc_wrong
ORDER BY c1;
{noformat}

So, it appears as if in the case row-mode might be wrong.

> Vectorization: Wrong results for vectorized_timestamp_funcs.q
> -------------------------------------------------------------
>
>                 Key: HIVE-17892
>                 URL: https://issues.apache.org/jira/browse/HIVE-17892
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.0.0
>            Reporter: Matt McCline
>            Assignee: Matt McCline
>            Priority: Critical
>
> Query #4:
> NonVec:
> NULL	NULL	NULL	NULL	NULL	NULL	8	1	1
> NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
> -62169765561	2	11	30	30	48	4	40	39
> Vec:
> NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
> NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
> NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)