hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thejas M Nair (JIRA)" <>
Subject [jira] [Commented] (HIVE-6012) restore backward compatibility of arithmetic operations
Date Wed, 29 Jan 2014 20:40:11 GMT


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:
>             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|]
> {code}
> int / int => decimal
> float / float => double
> float * float => double
> float + float => double
> {code}

This message was sent by Atlassian JIRA

View raw message