Still can't insert into delta tables Trino 425

[dishkakrauch]

Hi everybody.

Our Trino cluster is deployed in K8S and it still throws an error like that

SQL Error [13]: Query failed (#20230828_091632_00474_hbrtf): Writes are not enabled on the hdfs filesystem in order to avoid eventual data corruption which may be caused by concurrent data modifications on the table. Writes to the hdfs filesystem can be however enabled with the 'delta.enable-non-concurrent-writes' configuration property.

However we'd changed configMap (I checked coordinator /etc/ files)

we can insert into tables only with CTAS instrustion:

CREATE TABLE delta_adh2.stg.t_drop_me AS
(
SELECT 1 as id
FROM delta_adh2.prd.d_days
LIMIT 10
);

Following code will fail:

INSERT INTO delta_adh2.stg.t_drop_me
(id)
VALUES (2);

Can anybody help?

[findinpath]

The error message is misleading :( .

Trino doesn't offer support for writing on hdfs with the Delta Lake connector.

You are likely missing a few properties in your delta.properties file.

Have a look here at this example https://github.com/trinodb/trino/blob/master/testing/trino-server-dev/etc/catalog/delta.properties

[dishkakrauch]

@findinpath I understand than Trino doesn't offer support for this connector. I've just asked for a help - may be someone solved it earlier.
Following your link I didn't find any new parameters related to HDFS and Hive except proxy but it's irrelevant.

[findinpath]

At the time of this writing, Trino doesn't offer support for writing on hdfs with the Delta Lake connector.

[dishkakrauch]

How did you test your commit f7c64e5?
Looks like it's not discussion but like an issue.