Details
Major Description
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.
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)