[jira] [Created] (HIVE-14923) DATE and TIMESTAMP comparisons do not work

[Matt McCline (JIRA)]

Matt McCline created HIVE-14923:
-----------------------------------

             Summary: DATE and TIMESTAMP comparisons do not work
                 Key: HIVE-14923
                 URL: https://issues.apache.org/jira/browse/HIVE-14923
             Project: Hive
          Issue Type: Bug
          Components: Hive
            Reporter: Matt McCline
            Priority: Critical


When comparing a DATE type with a TIMESTAMP type, the planner promotes both 
sides to string.  But since the DATE value does not include the 
hh:mm:ss[.nnnnnnnnn] the comparison produces wrong results.

Thanks to Jason Dere for observing this.

Here is a portion of an EXPLAIN output:
{code}
                      Map Join Operator
                        condition map:
                             Inner Join 0 to 1
                        keys:
                          0 UDFToString(some_timestamp) (type: string)
                          1 UDFToString(some_date) (type: string)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)