[HIVE-21742] Vectorization: CASE result type casting

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.1.1
• Fix Version/s: 4.0.0-alpha-1
• Component/s: Logical Optimizer, Vectorization
• Labels: pull-request-available
• Assignee: Vineet Garg
• Reporter: Gopal Vijayaraghavan
• Created: 16/May/19 15:51
• Updated: 17/Nov/22 08:50
• Resolved: 08/Jun/19 04:32

Description

create temporary table foo(q548284 int);
insert into foo values(1),(2),(3),(4),(5),(6);
select q548284, CASE WHEN ((q548284 = 1)) THEN (0.2) WHEN ((q548284 = 2)) THEN (0.4) WHEN ((q548284 = 3)) THEN (0.6) WHEN ((q548284 = 4)) THEN (0.8) WHEN ((q548284 = 5)) THEN (1) ELSE (null) END from foo order by q548284 limit 1;

Fails with

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

This gets fixed if the case return of (1) is turned into a (1.0).

Issue Links

• links to: GitHub Pull Request #656

Sub-Tasks

• Improve Vectorizer type casting for WHEN expression: Closed