[HIVE-22640] Decimal64ColumnVector: ClassCastException when partition column type is Decimal

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Denys Kuzmenko
• Reporter: Denys Kuzmenko
• Created: 12/Dec/19 17:15
• Updated: 17/Nov/22 08:51
• Resolved: 21/Jan/20 15:39

Description

Problem statement:

CREATE EXTERNAL TABLE output (id DECIMAL(4,0), foo VARCHAR(10))
PARTITIONED BY (nr_bank *decimal*(4,0))
STORED AS ORC TBLPROPERTIES ('orc.compress'='ZLIB')

insert into output PARTITION (nr_bank=88) values (1,'test');
insert into output PARTITION (nr_bank=8801) values (1,'8801');

select count(*), nr_bank from sdlint.output group by nr_bank;

The above query fails with:

Caused by: java.lang.ClassCastException: org.apache.hadoop.hive.ql.exec.vector.DecimalColumnVector cannot be cast to org.apache.hadoop.hive.ql.exec.vector.LongColumnVector
at org.apache.hadoop.hive.ql.exec.vector.expressions.FuncLongToDecimal.evaluate(FuncLongToDecimal.java:58)

Issue Links

• is related to: HIVE-23004 Support Decimal64 operations across multiple vertices