SET allow_experimental_json_type=1;


CREATE TABLE test_new_json_type(id UInt32, data JSON, version UInt64) ENGINE=ReplacingMergeTree(version) ORDER BY id;

INSERT INTO test_new_json_type format JSONEachRow
{"id":1,"data":{"foo1":"bar"},"version":1}
{"id":2,"data":{"foo2":"bar"},"version":1}
{"id":3,"data":{"foo2":"bar"},"version":1}
;

SELECT
    a.data
    , b.data
FROM
    test_new_json_type a
    JOIN test_new_json_type b
        ON a.id = b.id;

DROP TABLE test_new_json_type;

