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

Posted to issues@calcite.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/11/30 21:05:12 UTC

[jira] [Created] (CALCITE-492) Support UPSERT DDL command in parser

James Taylor created CALCITE-492:
------------------------------------

             Summary: Support UPSERT DDL command in parser
                 Key: CALCITE-492
                 URL: https://issues.apache.org/jira/browse/CALCITE-492
             Project: Calcite
          Issue Type: Improvement
            Reporter: James Taylor
            Assignee: Julian Hyde


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)