trino icon indicating copy to clipboard operation
trino copied to clipboard

Full transaction support for Iceberg?

Open jiron12 opened this issue 2 years ago • 2 comments

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

jiron12 avatar Dec 13 '22 15:12 jiron12