Variant type

ddl.sql

SET
    allow_experimental_variant_type=1,
    use_variant_as_common_type = 1;

CREATE OR REPLACE TABLE test
(
    c Variant(Int64, String, Array(Variant(Int64, String)))
)
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]),
    (44),
    (''),
    ([26, 27]);


SELECT * FROM test;