[
https://issues.apache.org/jira/browse/PHOENIX-729?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-729.
----------------------------------
Resolution: Fixed
Bulk resolve of closed issues imported from GitHub. This status was reached by
first re-opening all closed imported issues and then resolving them in bulk.
> UPDATE TABLE Based on Condition
> -------------------------------
>
> Key: PHOENIX-729
> URL: https://issues.apache.org/jira/browse/PHOENIX-729
> Project: Phoenix
> Issue Type: Task
> Reporter: Nitin Kumar
>
> Hi,
> We have ,
> 1)UPSERT which update or insert a table ~ equivalent to insert of SQL+
> Update of sql without condition.
> 2)UPSERT SELECT- can update table based on condition. looks similar to SQL
> update statement. But major difference is we can't update a table with new
> set of values as select will work on existing table i.e update temp with
> existing table values.
> Common use case/ Issue:-
> Update a table with new set of values based on condition, i.e
> UPSERT based on condition.
> Can we have this common but very important feature of SQL?
> Thanks,
> Nitin
--
This message was sent by Atlassian JIRA
(v6.2#6252)
