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

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment