SET hive.vectorized.execution.enabled=true;
set hive.fetch.task.conversion=minimal;

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);

explain
select cast(t as boolean) from decimal_1 order by t;

select cast(t as boolean) from decimal_1 order by t;

explain
select cast(t as tinyint) from decimal_1 order by t;

select cast(t as tinyint) from decimal_1 order by t;

explain
select cast(t as smallint) from decimal_1 order by t;

select cast(t as smallint) from decimal_1 order by t;

explain
select cast(t as int) from decimal_1 order by t;

select cast(t as int) from decimal_1 order by t;

explain
select cast(t as bigint) from decimal_1 order by t;

select cast(t as bigint) from decimal_1 order by t;

explain
select cast(t as float) from decimal_1 order by t;

select cast(t as float) from decimal_1 order by t;

explain
select cast(t as double) from decimal_1 order by t;

select cast(t as double) from decimal_1 order by t;

explain
select cast(t as string) from decimal_1 order by t;

select cast(t as string) from decimal_1 order by t;

explain
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;