| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| SET hive.vectorized.execution.enabled=true; |
| set hive.fetch.task.conversion=none; |
| |
| drop table if exists decimal_1; |
| |
| create table decimal_1 (t decimal(4,2), u decimal(5), v decimal) stored as orc; |
| |
| desc decimal_1; |
| |
| insert overwrite table decimal_1 |
| select cast('17.29' as decimal(4,2)), 3.1415926BD, 3115926.54321BD from src tablesample (1 rows); |
| |
| -- Add a single NULL row that will come from ORC as isRepeated. |
| insert into decimal_1 values (NULL, NULL, NULL); |
| |
| explain vectorization detail |
| select cast(t as boolean) from decimal_1 order by t; |
| |
| select cast(t as boolean) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as tinyint) from decimal_1 order by t; |
| |
| select cast(t as tinyint) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as smallint) from decimal_1 order by t; |
| |
| select cast(t as smallint) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as int) from decimal_1 order by t; |
| |
| select cast(t as int) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as bigint) from decimal_1 order by t; |
| |
| select cast(t as bigint) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as float) from decimal_1 order by t; |
| |
| select cast(t as float) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as double) from decimal_1 order by t; |
| |
| select cast(t as double) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as string) from decimal_1 order by t; |
| |
| select cast(t as string) from decimal_1 order by t; |
| |
| explain vectorization detail |
| select cast(t as timestamp) from decimal_1 order by t; |
| |
| select cast(t as timestamp) from decimal_1 order by t; |
| |
| drop table decimal_1; |