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)