You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Matt McCline (JIRA)" <ji...@apache.org> on 2016/12/07 03:37:58 UTC
[jira] [Comment Edited] (HIVE-15338) Wrong result from vectorized DATEDIFF with scalar parameter of type DATE

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

Matt McCline edited comment on HIVE-15338 at 12/7/16 3:37 AM:
--------------------------------------------------------------

mysql> SELECT
    ->   fl_time,
    ->   datediff(fl_time, "2000-01-01"),
    ->   datediff(fl_time, date "2000-01-01"),
    ->   datediff(fl_time, "2007-03-14"),
    ->   datediff(fl_time, date "2007-03-14")
    -> FROM date_udf_flight_orc;
+---------------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| fl_time             | datediff(fl_time, "2000-01-01") | datediff(fl_time, date "2000-01-01") | datediff(fl_time, "2007-03-14") | datediff(fl_time, date "2007-03-14") |
+---------------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
...
+---------------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
137 rows in set (0.01 sec)

mysql> SELECT
    ->   fl_date,
    ->   datediff(fl_date, "2000-01-01"),
    ->   datediff(fl_date, date "2000-01-01"),
    ->   datediff(fl_date, "2007-03-14"),
    ->   datediff(fl_date, date "2007-03-14")
    -> FROM date_udf_flight_orc;
+------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| fl_date    | datediff(fl_date, "2000-01-01") | datediff(fl_date, date "2000-01-01") | datediff(fl_date, "2007-03-14") | datediff(fl_date, date "2007-03-14") |
+------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
...
+------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
137 rows in set (0.01 sec)
{code}

So, it turns out that vectorization is correct on this.


was (Author: mmccline):
According to the '*gold*' standard on this (MySQL):

{code}
mysql> SELECT
    ->   fl_time,
    ->   datediff(fl_time, "2000-01-01"),
    ->   datediff(fl_time, date "2000-01-01"),
    ->   datediff(fl_time, "2007-03-14"),
    ->   datediff(fl_time, date "2007-03-14")
    -> FROM date_udf_flight_orc;
+---------------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| fl_time             | datediff(fl_time, "2000-01-01") | datediff(fl_time, date "2000-01-01") | datediff(fl_time, "2007-03-14") | datediff(fl_time, date "2007-03-14") |
+---------------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 07:00:00 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 07:00:00 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 07:00:00 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 07:00:00 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 07:00:00 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 07:00:00 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 07:00:00 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 07:00:00 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 07:00:00 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 07:00:00 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 07:00:00 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 07:00:00 |                            3956 |                                 3956 |                            1327 |                                 1327 |
+---------------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
137 rows in set (0.01 sec)

mysql> SELECT
    ->   fl_date,
    ->   datediff(fl_date, "2000-01-01"),
    ->   datediff(fl_date, date "2000-01-01"),
    ->   datediff(fl_date, "2007-03-14"),
    ->   datediff(fl_date, date "2007-03-14")
    -> FROM date_udf_flight_orc;
+------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| fl_date    | datediff(fl_date, "2000-01-01") | datediff(fl_date, date "2000-01-01") | datediff(fl_date, "2007-03-14") | datediff(fl_date, date "2007-03-14") |
+------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-20 |                            3945 |                                 3945 |                            1316 |                                 1316 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-21 |                            3946 |                                 3946 |                            1317 |                                 1317 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-22 |                            3947 |                                 3947 |                            1318 |                                 1318 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-23 |                            3948 |                                 3948 |                            1319 |                                 1319 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-24 |                            3949 |                                 3949 |                            1320 |                                 1320 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-25 |                            3950 |                                 3950 |                            1321 |                                 1321 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-26 |                            3951 |                                 3951 |                            1322 |                                 1322 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-27 |                            3952 |                                 3952 |                            1323 |                                 1323 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-28 |                            3953 |                                 3953 |                            1324 |                                 1324 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-29 |                            3954 |                                 3954 |                            1325 |                                 1325 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-30 |                            3955 |                                 3955 |                            1326 |                                 1326 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
| 2010-10-31 |                            3956 |                                 3956 |                            1327 |                                 1327 |
+------------+---------------------------------+--------------------------------------+---------------------------------+--------------------------------------+
137 rows in set (0.01 sec)
{code}

So, vectorized output turns out to be correct in this case.

> 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)