How do you define a primary key on a table in Trino?

Question

The query below does not work.

CREATE TABLE test_table (date varchar, id varchar, PRIMARY KEY (date,id)) 

I can't seem to find any docs on primary keys in Trino.

Midget

Answer 1

You don't. As the description says:

Trino is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources.

Trino does not maintain primary keys, indexes and so on. See also use cases and Trino concepts.

Ciri

delta lake has foreign keys now, but not supported in trino yet. maybe down the road? would be handy for tools like metabase where you should specify your keys – Photocompose

@NeilMcGuigan I doubt it, since Trino is a query engine which does not usually stores the data (unlike delta lake) but processes it. – Ciri