| --! qt:dataset:src |
| set hive.fetch.task.conversion=more; |
| |
| -- test for TINYINT |
| select round(-128), round(127), round(0) from src tablesample (1 rows); |
| |
| -- test for SMALLINT |
| select round(-32768), round(32767), round(-129), round(128) from src tablesample (1 rows); |
| |
| -- test for INT |
| select round(cast(negative(pow(2, 31)) as INT)), round(cast((pow(2, 31) - 1) as INT)), round(-32769), round(32768) from src tablesample (1 rows); |
| |
| -- test for BIGINT |
| select round(cast(negative(pow(2, 63)) as BIGINT)), round(cast((pow(2, 63) - 1) as BIGINT)), round(cast(negative(pow(2, 31) + 1) as BIGINT)), round(cast(pow(2, 31) as BIGINT)) from src tablesample (1 rows); |
| |
| -- test for DOUBLE |
| select round(126.1), round(126.7), round(32766.1), round(32766.7) from src tablesample (1 rows); |