[
https://issues.apache.org/jira/browse/HIVE-17061?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16790519#comment-16790519
]
Shawn Weeks commented on HIVE-17061:
------------------------------------
Looks like HIVE-20590 may have been a duplicate of this.
> Add Support for Column List in Insert Clause
> --------------------------------------------
>
> Key: HIVE-17061
> URL: https://issues.apache.org/jira/browse/HIVE-17061
> Project: Hive
> Issue Type: Improvement
> Components: Transactions
> Reporter: Shawn Weeks
> Priority: Minor
>
> 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.
> {code}
> 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)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
