Support row-level modification in Cassandra connector

[sandy4597niko]

Hi Team,

I’m using Apache Superset (v4.1.3) with Trino (v1.40.0) as a mediator to query Cassandra databases. Since Superset cannot directly connect to Cassandra, I’ve configured Trino with the Cassandra catalog, and most operations (SELECT, etc.) work fine.

However, I’m unable to execute UPDATE statements. Superset (via Trino → Cassandra) throws the following error:

TrinoUserError(type=USER_ERROR, name=NOT_SUPPORTED,
message="This connector does not support modifying table rows",
query_id=20250826_113945_00055_gpya8)

Example query:

UPDATE test_table_2
SET test = '3'
WHERE partner_id = '321'
AND client_id = '123'
AND site_id = '123'
AND endpoint_id = '12345'
AND ip_address = '192.x.x.x';

Is support for UPDATE operations planned for the Trino connector in Superset, or is this a known limitation by design?

[ebyhr]

The client tool (Superset) is unrelated. It's a known limitation of Cassandra connector as https://trino.io/docs/current/connector/cassandra.html#sql-support doesn't mention UPDATE statement.

[sandy4597niko]

@ebyhr when can I expect this to be fixed in trino level ?

[ebyhr]

There is no plan to support it. Please feel free to send a PR.

[codluca]

Created pull request: #26680