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

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/02/08 09:56:44 UTC

[jira] [Closed] (CALCITE-492) Support UPSERT statement in parser

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

Julian Hyde closed CALCITE-492.
-------------------------------

Closing now that 1.0.0-incubating has been released.

> Support UPSERT statement in parser
> ----------------------------------
>
>                 Key: CALCITE-492
>                 URL: https://issues.apache.org/jira/browse/CALCITE-492
>             Project: Calcite
>          Issue Type: Sub-task
>            Reporter: James Taylor
>            Assignee: Julian Hyde
>              Labels: phoenix
>             Fix For: 1.0.0-incubating
>
>
> Support an UPSERT VALUES and UPSERT SELECT statement in Calcite. These have the same syntax as INSERT VALUES and INSERT SELECT, but they insert the row if it doesn't already exist and update it otherwise. This is a pretty common pattern for big data applications that want to have an option to write without reading first. See http://phoenix.apache.org/language/index.html#upsert_values and http://phoenix.apache.org/language/index.html#upsert_select for syntax.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)