Recently, i came across some problems in my hive application, i wondered if it is a bug in hive or did some else has the same experience. the problem is as follows:
drop table if exists tb_int;
create table tb_int(val int);
insert into tb_int values(1);
drop table if exists tb_bigint;
create table tb_bigint(val bigint);
insert into tb_bigint values(11);
insert into tb_int select abs(val) from tb_bigint;
select * from tb_int;
i expected the result is :
bu , what i actually got is:
I think the result is not reasonable, is it a bug in hive? my hive version is 2.3.3， and i tested the 2.3.0 version， the result is the same.
Could someone give some help, thanks!