[
https://issues.apache.org/jira/browse/PHOENIX-7651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Viraj Jasani updated PHOENIX-7651:
----------------------------------
Description:
PHOENIX-7630 made it possible to use standard JDBC API to fetch the row with
UPSERT ... ON DUPLICATE KEY statement, but it is unconditional and not
efficient for use cases that do not need the row, especially if the row is
large. This feature should support a {{RETURNING *}} clause to make it
possible for the user to conditionally fetch the row.
This is inspired by [https://www.postgresql.org/docs/17/dml-returning.html]
was:PHOENIX-7630 made it possible to use standard JDBC API to fetch the row
with UPSERT ... ON DUPLICATE KEY statement, but it is unconditional and not
efficient for use cases that do not need the row, especially if the row is
large. This feature should support a {{RETURNING *}} clause to make it
possible for the user to conditionally fetch the row.
> Support for RETURNING clause with UPSERT ... ON DUPLICATE KEY
> -------------------------------------------------------------
>
> Key: PHOENIX-7651
> URL: https://issues.apache.org/jira/browse/PHOENIX-7651
> Project: Phoenix
> Issue Type: New Feature
> Reporter: Hari Krishna Dara
> Priority: Major
>
> PHOENIX-7630 made it possible to use standard JDBC API to fetch the row with
> UPSERT ... ON DUPLICATE KEY statement, but it is unconditional and not
> efficient for use cases that do not need the row, especially if the row is
> large. This feature should support a {{RETURNING *}} clause to make it
> possible for the user to conditionally fetch the row.
> This is inspired by [https://www.postgresql.org/docs/17/dml-returning.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
