Full transaction support for Iceberg?

[jiron12]

Is full transaction support for Iceberg on the roadmap?

What I tried (SQL):

START TRANSACTION;

insert into my_trino_schema.my_table
select 43, 'hello world 2', 12.12;

insert into my_trino_schema.my_table2
select 43, 'hello end of the world', 42.42 / 0; -- <-- division by zero, leading to rollback

COMMIT WORK;

What I got (Error message):
SQL Error [25]: Query failed (#20221213_145826_00039_it4nx): Catalog only supports writes using autocommit: iceberg

Probably I'm naive here, but with time travelling already supported in Iceberg, this might not be a huge thing? Coming from the traditional SQL Systems, this is still missing.

I put this question to iceberg first, as I thought they had to change something on their side:
apache/iceberg#6418

[findepi]

Is full transaction support for Iceberg on the roadmap?

it's not

we would rather remove transaction support altogether, since it's pretty complex code to maintain and it's not correct even for the only connector which claims transaction support

see eg #11769 (comment)

[jiron12]

Looks like Iceberg is about to support multi-table transactions:
apache/iceberg#6948