[HIVE-20144] Casting of Decimal Data Selected from ORC table and Insert to the Target table not working.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.2.1
• Component/s: Query Processor, SQL, SQLStandardAuthorization

Environment

HDP 2.6.4, Centos7 

• Assignee: Unassigned
• Reporter: Sunil Kumar
• Due: 12/Jul/18
• Created: 11/Jul/18 21:41
• Updated: 11/Jul/18 21:41

Description

Decimal Data Selected from ORC table and inserted to Hive Target table Cast Operator not working for the Decimal data Type. When data selected from ORC table and Specifically cast written to cast to value but data in the target table not getting casted to precision and scale mentioned with the CAST operator.

create table tbl_src_txt(col1 decimal(10,7)) stored as textfile;

create table tbl_src_orc(col1 decimal(10,7)) stored as orc;

create table tbl_TGT_TXT(col1 decimal(10,7)) stored as orc;

insert into tbl_src_txt select -145.299999 from (select 1)tbl;

insert into tbl_src_orc select -149.299999 from (select 1)tbl;

Data in Source Tables:
hive> select * from tbl_src_txt;
OK
-145.299999
Time taken: 0.056 seconds, Fetched: 1 row(s)
hive> select * from tbl_src_orc;
OK
-149.299999
Time taken: 0.11 seconds, Fetched: 1 row(s)
hive>

Insert into Target table from both Source table:

insert into tbl_TGT_TXT select cast(col1 as decimal(4,1)) from tbl_src_txt;

insert into tbl_TGT_TXT select cast(col1 as decimal(4,1)) from tbl_src_orc;

hive> select * from tbl_TGT_TXT;
OK
-145.3
-149.299999
Time taken: 0.065 seconds, Fetched: 2 row(s)
hive>