You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Shawn Weeks (JIRA)" <ji...@apache.org> on 2017/07/07 21:29:00 UTC

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

Shawn Weeks created HIVE-17061:
----------------------------------

             Summary: Add Support for Column List in Insert Clause
                 Key: HIVE-17061
                 URL: https://issues.apache.org/jira/browse/HIVE-17061
             Project: Hive
          Issue Type: Sub-task
          Components: Hive
            Reporter: Shawn Weeks
            Priority: Minor


Include support for a list of columns in the insert clause of the merge statement.

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