v0.1 Columnstore DDL (USING columnstore)

Create Columnstore Table (v0.1)

In v0.1, columnstore tables were created directly with the USING columnstore clause:

CREATE TABLE users_columnstore (
    id INT,
    name TEXT,
    created_at TIMESTAMP
) USING columnstore;

-- Or via CREATE TABLE ... AS SELECT
CREATE TABLE users_columnstore USING columnstore AS
    SELECT * FROM users_rowstore;

Drop Columnstore Table

DROP TABLE users_columnstore;

Supported Features & Limitations in v0.1

• Supported: INSERT, UPDATE, DELETE, ACID transactions, NOT NULL constraints, default values, and joins with heap tables.
• Unsupported Data Types in v0.1: ENUM, uhugeint, JSONB (partial), and complex arrays.
• Unsupported Constraints in v0.1: Primary keys, foreign keys, unique constraints, indexes, and partitioned tables (ALTER TABLE schema changes required recreating the table).

Setting columnstore as Default Table Access Method (v0.1)

SET default_table_access_method = 'columnstore';