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)

Reply via email to