[
https://issues.apache.org/jira/browse/HIVE-6012?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13885789#comment-13885789
]
Thejas M Nair commented on HIVE-6012:
-------------------------------------
There are some practical problems with introducing a hive.sql.ansi flag. Lets
say a hive user turns it to true in hive 0.13 and write several queries using
hive 0.13. Then in hive 0.14 we find some other desirable standards compatible
behavior (but backward incompatible with earlier versions of hive) and we
control that using same flag. When the user upgrades to hive 0.14, the user
queries can break with either values for the flag.
I think it is better to have a more specific flag, say hive.sql.ansi.arithmetic
Since the behavior of float arithmetic in hive 0.12 was SQL compliant, I think
we can go back to old behavior without this config option. There more
configurable the behavior is, there more untested configurations there will be.
> restore backward compatibility of arithmetic operations
> -------------------------------------------------------
>
> Key: HIVE-6012
> URL: https://issues.apache.org/jira/browse/HIVE-6012
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Affects Versions: 0.13.0
> Reporter: Thejas M Nair
> Assignee: Jason Dere
> Attachments: HIVE-6012.1.patch, HIVE-6012.2.patch, HIVE-6012.3.patch
>
>
> HIVE-5356 changed the behavior of some of the arithmetic operations, and the
> change is not backward compatible, as pointed out in this [jira
> comment|https://issues.apache.org/jira/browse/HIVE-5356?focusedCommentId=13813398&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-13813398]
> {code}
> int / int => decimal
> float / float => double
> float * float => double
> float + float => double
> {code}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
