You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Vineet Garg (JIRA)" <ji...@apache.org> on 2018/03/27 00:55:00 UTC

[jira] [Commented] (HIVE-19059) Support DEFAULT keyword with INSERT and UPDATE

    [ https://issues.apache.org/jira/browse/HIVE-19059?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16414834#comment-16414834 ] 

Vineet Garg commented on HIVE-19059:
------------------------------------

First patch provide support for INSERT and UPDATE. MERGE has yet to be supported.

> Support DEFAULT keyword with INSERT and UPDATE
> ----------------------------------------------
>
>                 Key: HIVE-19059
>                 URL: https://issues.apache.org/jira/browse/HIVE-19059
>             Project: Hive
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Vineet Garg
>            Assignee: Vineet Garg
>            Priority: Major
>             Fix For: 3.0.0
>
>         Attachments: HIVE-19059.1.patch
>
>
> Support DEFAULT keyword in INSERT e.g.
> {code:sql}
> INSERT INTO TABLE t values (DEFAULT, DEFAULT)
> {code}
> or with UPDATE
> {code:sql}
> UPDATE TABLE t SET col1=DEFAULT WHERE col2 > 4
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)