[
https://issues.apache.org/jira/browse/HIVE-17061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ashutosh Chauhan resolved HIVE-17061.
-------------------------------------
Resolution: Fixed
Fix Version/s: 4.0.0
Resolved via HIVE-20590
> 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
> Fix For: 4.0.0
>
>
> 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)
