UPDATE statement

[findepi]

• Support SQL UPDATE in the Presto Engine and Hive ACID Tables #5861
• Support SQL UPDATE of partition and bucket columns in the Trino engine #6772
• Support SQL UPDATE of partition and bucket columns in the Hive connector #6773
• SQL UPDATE - - update table and partition statistics in the Hive connector #6774
• UPDATE should support subqueries in assignments (SET)
  • uncorrelated (Support uncorrelated subquery in UPDATE SET #8267)
  • correlated Support correlated subquery in UPDATE assignments (SET) #8286
• Hive cannot read ORC ACID table updated by Trino twice #8268

relates to #7708

[djsstarburst]

PR #5861 implements SQL UPDATE in the Presto engine, and updates the Hive connector to support SQL UPDATE for Hive ACID tables. The PR contains a new Developer documentation page explaining in detail the API and theory of operation for UPDATE: 0966644#diff-b842ca279826a809534f2970ae7bf07fab1e8727bc4866fddb48b8c3ced809eaR1

[djsstarburst]

#5861 has been merged. However, I'm unable to edit this issue to check it off.

[LexxaRRioo]

Hello! What do you think about UPDATE FROM section support? You can see examples here: https://www.postgresql.org/docs/current/sql-update.html

As far as I know, now it is impossible to update table A based on condition from table B even in WHERE section:

update table_val val
set to_delete = false
where not exists (
  select 1
  from table_map map
  where val.id = map.val_id
);

[djsstarburst]

I don't have an opinion about this suggestion. @martint is the expert on these matters, and he would have to endorse the change.