trino
trino copied to clipboard
Full transaction support for Iceberg?
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: https://github.com/apache/iceberg/issues/6418