[jira] [Updated] (HIVE-17061) Add Support for Column List in Insert Clause

["Eugene Koifman (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-17061?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eugene Koifman updated HIVE-17061:
----------------------------------
    Issue Type: Improvement  (was: Sub-task)
        Parent:     (was: HIVE-10924)

> 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
(v6.4.14#64029)