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

Add support for multiple WHEN MATCHED clauses

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Duplicate
    • None
    • None
    • Transactions
    • None

    Description

      Different vendors have different rules.
      HIVE-14943 only allows 1 WHEN MATCHED clause

      IBM Allows > 1 WHEN MATCHED clause https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0010873.html

      So does SQL Server https://msdn.microsoft.com/en-us/library/bb510625.aspx

      everyone seems to support update/delete/insert - in that order

      Attachments

        Issue Links

          duplicates

          Sub-task - The sub-task of the issue HIVE-14943 Base Implementation

          • 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: