Skip to content

Instantly share code, notes, and snippets.

@tom-clickhouse
Created October 18, 2024 07:10
Show Gist options
  • Save tom-clickhouse/558b82bb6e7dbb00dbbf0f669012b64a to your computer and use it in GitHub Desktop.
Save tom-clickhouse/558b82bb6e7dbb00dbbf0f669012b64a to your computer and use it in GitHub Desktop.
fixed data types
CREATE OR REPLACE TABLE test
(
c1 Int64,
c2 Nullable(String),
c3 Array(Int64)
)
ENGINE = MergeTree
ORDER BY tuple()
SETTINGS
min_bytes_for_wide_part = 1,
min_rows_for_wide_part = 1;
INSERT INTO test values
(42, 'foo', [23, 24]),
(43, Null, [25]),
(43, '', [26, 27]);
SELECT * FROM test;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment