[
https://issues.apache.org/jira/browse/HIVE-15338?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15727632#comment-15727632
]
Matt McCline commented on HIVE-15338:
-------------------------------------
------------------------------------------------------------------------------------------------------
Time
non-vec
3945 3945 3945 *3944* 1316 1316 1316 *1315*
vec
3945 3945 3945 3945 1316 1316 1316 1316
#4 WRONG datediff(fl_time, timestamp "2000-01-01 11:13:09"),
#8 WRONG datediff(fl_time, timestamp "2007-03-14 08:21:59")
------------------------------------------------------------------------------------------------------
Date
non-vec
3945 *3944* *3944* *3944* 1316 1316 1316 *1315*
vec
3945 3945 3945 3945 1316 1316 1316 1316
#2 WRONG datediff(fl_date, date "2000-01-01"),
#3 WRONG datediff(fl_date, timestamp "2000-01-01 00:00:00"),
#4 WRONG datediff(fl_date, timestamp "2000-01-01 11:13:09"),
#8 WRONG datediff(fl_date, timestamp "2007-03-14 08:21:59")
> Wrong result from vectorized DATEDIFF with scalar parameter of type DATE
> ------------------------------------------------------------------------
>
> Key: HIVE-15338
> URL: https://issues.apache.org/jira/browse/HIVE-15338
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: Matt McCline
> Assignee: Matt McCline
> Priority: Critical
> Attachments: HIVE-15338.01.patch
>
>
> Vectorization in vectorized DATEDIFF when parameter is (date '12-01-16',
> column). Jason noted that ('12-01-16', column) treats the first parameter as
> a string and is a different case.
> Current Q file test vectorized_date_funcs.q DOES NOT test the date scalar
> type case.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
