| --! qt:dataset:src |
| set hive.fetch.task.conversion=more; |
| |
| -- cast string floats to integer types |
| select |
| cast('1' as float), |
| cast('1.4' as float), |
| cast('1.6' as float), |
| cast('1' as int), |
| cast('1.4' as int), |
| cast('1.6' as int), |
| cast('1' as tinyint), |
| cast('1.4' as tinyint), |
| cast('1.6' as tinyint), |
| cast('1' as smallint), |
| cast('1.4' as smallint), |
| cast('1.6' as smallint), |
| cast('1' as bigint), |
| cast('1.4' as bigint), |
| cast('1.6' as bigint), |
| cast (cast('1' as float) as int), |
| cast(cast ('1.4' as float) as int), |
| cast(cast ('1.6' as float) as int), |
| cast('+1e5' as int), |
| cast('2147483647' as int), |
| cast('-2147483648' as int), |
| cast('32767' as smallint), |
| cast('-32768' as smallint), |
| cast('-128' as tinyint), |
| cast('127' as tinyint), |
| cast('1.0a' as int), |
| cast('-1.-1' as int) |
| from src tablesample (1 rows); |