Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21837

MapJoin is throwing exception when selected column is having completely null values

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 4.0.0-alpha-1
    • None
    • None

    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

      Attachments

        1. HIVE-21837.1.patch
          1 kB
          Naresh P R
        2. HIVE-21837.2.patch
          1 kB
          Naresh P R
        3. HIVE-21837.3.patch
          6 kB
          Naresh P R
        4. HIVE-21837.4.patch
          10 kB
          Naresh P R
        5. HIVE-21837.5.patch
          10 kB
          Naresh P R
        6. HIVE-21837.6.patch
          31 kB
          Naresh P R

        Activity

          People

            nareshpr Naresh P R
            nareshpr Naresh P R
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: