hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Matt McCline (JIRA)" <>
Subject [jira] [Created] (HIVE-14923) DATE and TIMESTAMP comparisons do not work
Date Mon, 10 Oct 2016 22:30:20 GMT
Matt McCline created HIVE-14923:

             Summary: DATE and TIMESTAMP comparisons do not work
                 Key: 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:
                      Map Join Operator
                        condition map:
                             Inner Join 0 to 1
                          0 UDFToString(some_timestamp) (type: string)
                          1 UDFToString(some_date) (type: string)

This message was sent by Atlassian JIRA

View raw message