https://delta.io logo
m

Madhumita Bharde

07/21/2023, 5:23 PM
Using trino delta lake connector. Wanted to see the CDC for the table https://trino.io/docs/current/connector/delta-lake.html#table-changes
Copy code
trino> SELECT
    ->     *
    ->     FROM
    ->     TABLE(
    ->     system.table_changes(
    ->    ...
    ->     )
    ->     );
Query 20230721_165254_00029_38j29 failed: line 5:5: Table function system.table_changes not registered
EMR 6.12/Trino 414
created table using
Copy code
trino> CREATE TABLE delta.<>.<> (
    ->             dummy bigint
    ->             )
    ->             WITH (
    ->             location = '<>',
    ->      change_data_feed_enabled = true
    ->             );
CREATE TABLE
trino>
I got an answer on Trino Slack channel. Apparently the feature is available in Trino 418 and later