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

Istvan Toth commented on PHOENIX-286:
-------------------------------------

While using batch upserts without autocommit is kind of a workaround, having 
this functionality would be both faster and easier, for example it wouldn't 
require a lot of round trips when going through query server.

I could not find the SQL standard for upsert, but at least one oracle product 
seems to implement this syntax:
https://docs.oracle.com/en/database/other-databases/nosql-database/22.3/sqlreferencefornosql/upsert-statement.html

> UPSERT VALUES does not support multiple values
> ----------------------------------------------
>
>                 Key: PHOENIX-286
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-286
>             Project: Phoenix
>          Issue Type: Task
>            Reporter: Raymond Liu
>
> since there are support for UPSERT Select, I guess to support UPSERT multiple 
> VALUES is   not a problem?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to