hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashutosh Chauhan (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-17061) Add Support for Column List in Insert Clause
Date Tue, 12 Mar 2019 21:04:00 GMT

     [ 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)

Mime
View raw message