[HIVE-12209] Vectorized simple CASE expressions with nulls

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.1, 1.3.0, 2.0.0
• Fix Version/s: 2.0.0
• Component/s: Vectorization
• Release Note: Vectorize simple UDFs with null arguments
• Assignee: Gopal Vijayaraghavan Assign to me
• Reporter: Gopal Vijayaraghavan
• Created: 18/Oct/15 07:32
• Updated: 16/Feb/16 23:50
• Resolved: 03/Nov/15 03:43

Description

CASE when (d_day_name='Sunday') then ss_sales_price else null end

2015-10-18T03:28:37,911 INFO  [main]: physical.Vectorizer (Vectorizer.java:validateExprNodeDesc(1360)) - Failed to vectorize
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to vectorize custom UDF. Custom udf containing constant null argument cannot be currently vectorized.

Issue Links

• relates to: HIVE-12435 SELECT COUNT(CASE WHEN...) GROUPBY returns 1 for 'NULL' in a case of ORC and vectorization is enabled.