[HIVE-21837] MapJoin is throwing exception when selected column is having completely null values

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 4.0.0-alpha-1
• Target Version/s: 4.0.0
• Assignee: Naresh P R
• Reporter: Naresh P R
• Created: 05/Jun/19 14:44
• Updated: 17/Nov/22 08:50
• Resolved: 11/Jun/19 15:17

Description

With huge data, below query

SELECT
 a.id,
 null
 FROM table a 
 JOIN table b ON (a.id = b.id)
 JOIN (SELECT '1234' id, 'deptno' type UNION ALL SELECT '5678' id, 'deptno' type) c ON (c.type = a.type)

is throwing below exception.

Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Column vector class org.apache.hadoop.hive.ql.exec.vector.VoidColumnVector is not supported!
 at org.apache.hadoop.hive.ql.exec.vector.VectorizedBatchUtil.makeLikeColumnVector(VectorizedBatchUtil.java:624)
 at org.apache.hadoop.hive.ql.exec.vector.VectorizedBatchUtil.makeLike(VectorizedBatchUtil.java:861)
 at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinCommonOperator.commonSetup(VectorMapJoinCommonOperator.java:583)
 at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinGenerateResultOperator.commonSetup(VectorMapJoinGenerateResultOperator.java:128)
 at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinInnerGenerateResultOperator.commonSetup(VectorMapJoinInnerGenerateResultOperator.java:112)
 at org.apache.hadoop.hive.ql.exec.vector.mapjoin.VectorMapJoinInnerMultiKeyOperator.process(VectorMapJoinInnerMultiKeyOperator.java:119)
 ... 21 more