--! qt:dataset:src
set hive.optimize.skewjoin=true;
set hive.auto.convert.join=false;

drop table if exists decimal_skewjoin_1;
drop table if exists decimal_skewjoin_2;

create table decimal_skewjoin_1 (t decimal(4,2), u decimal(5), v decimal);
create table decimal_skewjoin_2 (t decimal(4,2), u decimal(5), v decimal);

insert overwrite table decimal_skewjoin_1
  select cast('17.29' as decimal(4,2)), 3.1415926BD, 3115926.54321BD from src tablesample (1 rows);

insert overwrite table decimal_skewjoin_2
  select cast('17.29' as decimal(4,2)), 3.1415926BD, 3115926.54321BD from src tablesample (1 rows);

select a.u from decimal_skewjoin_1 a INNER JOIN decimal_skewjoin_2 b ON a.t=b.t;

drop table decimal_skewjoin_1;
drop table decimal_skewjoin_2;