[jira] Commented: (HIVE-774) Fix the behavior of "/" and add "DIV"

["Edward Capriolo (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12745448#action_12745448 ] 

Edward Capriolo commented on HIVE-774:
--------------------------------------

I have not had to deal with many hive precision issues, also I do not really have an opinion on how things should work. But I think we might want to consider deferring to how Java does things rather then how MySQL handles things. 
On one had its nice to handle things like the mysql reference says to handle things. Of course the mysql reference will have from subtle to not so subtle changes between versions. 

While I think it is great to have all the UDF's that mysql may have, I don't think we should always defer to doing something as mysql would, unless mysql is doing it to match some larger SQL standard.

> Fix the behavior of "/" and add "DIV"
> -------------------------------------
>
>                 Key: HIVE-774
>                 URL: https://issues.apache.org/jira/browse/HIVE-774
>             Project: Hadoop Hive
>          Issue Type: Bug
>    Affects Versions: 0.4.0, 0.5.0
>            Reporter: Zheng Shao
>            Assignee: Ning Zhang
>             Fix For: 0.4.0, 0.5.0
>
>         Attachments: hive-774.patch
>
>
> In hive, "select 3/2" will return 1 while MySQL returns 1.5.
> See http://dev.mysql.com/doc/refman/5.0/en/arithmetic-functions.html#operator_div for details.
> {code}
> mysql> select 3/2;
> +--------+
> | 3/2    |
> +--------+
> | 1.5000 |
> +--------+
> 1 row in set (0.00 sec)
> mysql> select 3 div 2;
> +---------+
> | 3 div 2 |
> +---------+
> |       1 |
> +---------+
> 1 row in set (0.00 sec)
> mysql> select -3 div 2;
> +----------+
> | -3 div 2 |
> +----------+
> |       -1 |
> +----------+
> 1 row in set (0.00 sec)
> mysql> select -3 div -2;
> +-----------+
> | -3 div -2 |
> +-----------+
> |         1 |
> +-----------+
> 1 row in set (0.00 sec)
> mysql> select 3 div -2;
> +----------+
> | 3 div -2 |
> +----------+
> |       -1 |
> +----------+
> 1 row in set (0.00 sec)
> {code}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.