[jira] [Commented] (PHOENIX-7198) support for multi row constructors in single upsert query

["Viraj Jasani (Jira)" <ji...@apache.org>]

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

Viraj Jasani commented on PHOENIX-7198:
---------------------------------------

[~richardantal] could you also help backport the changes to 5.3 branch?

> support for multi row constructors in single upsert query
> ---------------------------------------------------------
>
>                 Key: PHOENIX-7198
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7198
>             Project: Phoenix
>          Issue Type: New Feature
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Richárd Antal
>            Priority: Major
>             Fix For: 5.4.0
>
>         Attachments: MultipleUpsertPerfIT.java
>
>
> Multi-row constructors in an INSERT query are part of the ANSI SQL:2003 standard. They allow you to insert multiple rows with a single statement, as shown in the example below:
> INSERT INTO table_name (column1, column2, column3, ...)
> VALUES 
>     (value1, value2, value3, ...),
>     (value1, value2, value3, ...),
>     ...
> would be better to support. 



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