[
https://issues.apache.org/jira/browse/HIVE-8391?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164187#comment-14164187
]
Jason Dere commented on HIVE-8391:
----------------------------------
Though I'm not sure about patch v1 as the best fix for this issue - this allows
numeric-to-timestamp comparisons by allowing implicit conversions between
double and timestamps. I don't want to just enable implicit conversions - for
example it was a change which allowed implicit conversions between string and
dates/timestamps which seems to have caused this particular issue about
numeric-to-timestamp comparisons in the first place.
> Comparion between TIMESTAMP and Integer types goes to STRING as "common
> comparison denominator" instead of a numeric type
> -------------------------------------------------------------------------------------------------------------------------
>
> Key: HIVE-8391
> URL: https://issues.apache.org/jira/browse/HIVE-8391
> Project: Hive
> Issue Type: Bug
> Components: CBO, Logical Optimizer
> Affects Versions: 0.14.0
> Reporter: Matt McCline
> Assignee: Jason Dere
> Priority: Critical
> Fix For: 0.14.0
>
> Attachments: HIVE-8391.1.patch, vectorization_7.q
>
>
> Discovered while investigating why vectorization_7.q has different results
> for non-vectorized [+CBO] and vectorized [+CBO].
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
