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

Add Support for Column List in Insert Clause

          Details

          • Type: Improvement
          • Status: Resolved
          • Priority: Minor
          • Resolution: Fixed
          • Affects Version/s: None
          • Fix Version/s: 4.0.0
          • Component/s: Transactions
          • Labels:
            None

            Description

            Include support for a list of columns in the insert clause of the merge statement. This helps when you may not know or care about the order of columns in the target table or if you don't want to have to insert values into all of the columns.

            MERGE INTO target 
USING source ON b = y
WHEN MATCHED AND c + 1 + z > 0
THEN UPDATE SET a = 1, c = z
WHEN NOT MATCHED AND z IS NULL
THEN INSERT(a,b) VALUES(z, 7)

              Attachments

                Issue Links

                depends upon

                New Feature - A new feature of the product, which has yet to be developed. HIVE-10924 add support for MERGE statement

                • Major - Major loss of function.
                • Resolved

                  Activity

                    People

                    • Assignee:
                      Unassigned
                      Reporter:
                      Absolutesantaja Shawn Weeks
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: