Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-10924 add support for MERGE statement
  3. HIVE-15839

Don't force cardinality check if only WHEN NOT MATCHED is specified

    XMLWordPrintableJSON

Details

    Description

      should've been part of HIVE-14949

      if only WHEN NOT MATCHED is specified then the join is basically an anti-join and we are not retrieving any values from target side. So the cardinality check is just overhead (though presumably very minor since the filter above the join will filter everything and thus there is nothing to group)

      Attachments

        1. HIVE-15839.01.patch
          8 kB
          Eugene Koifman
        2. HIVE-15839.02.patch
          8 kB
          Eugene Koifman
        3. HIVE-15839.03.patch
          8 kB
          Eugene Koifman

        Issue Links

          is blocked by

          Sub-task - The sub-task of the issue HIVE-15871 Cannot insert into target table because column number/types are different with hive.merge.cardinality.check=false

          • Major - Major loss of function.
          • Closed
          relates to

          Sub-task - The sub-task of the issue HIVE-14949 Add Cardinality Violation check in SQL MERGE stmt

          • Major - Major loss of function.
          • Closed

          Activity

            People

              ekoifman Eugene Koifman
              ekoifman Eugene Koifman
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: