Naresh P R created HIVE-21837: --------------------------------- Summary: MapJoin is throwing exception when selected column is having completely null values Key: HIVE-21837 URL: https://issues.apache.org/jira/browse/HIVE-21837 Project: Hive Issue Type: Bug Reporter: Naresh P R Assignee: Naresh P R
With huge data, below query {code:java} 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){code} is throwing below exception. {code:java} 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{code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)