v.1.1.54362New Feature

Using MergeTree Tables Without a Primary Key

Official CH changelog text
MergeTree tables can be used without a primary key (you need to specify ORDER BY tuple()).
MergeTree tables now support usage without a primary key by specifying ORDER BY tuple().

Why it matters

This feature allows users to create MergeTree tables without defining a primary key, providing more flexibility in table design when the primary key is not needed or desired.

How to use it

To create a MergeTree table without a primary key, use ORDER BY tuple() in the table definition, for example:

CREATE TABLE example_table (
    id UInt32,
    value String
) ENGINE = MergeTree()
ORDER BY tuple()
PreviousNext