记clickhouse 的Array(Int32)字段类型等等

CREATE TABLE xxx_table
(
    `id` UUID  DEFAULT generateUUIDv4(),
    `create_time` DateTime  DEFAULT now(),
    `list` Array(Int32)
)
ENGINE = MergeTree
PRIMARY KEY id
PARTITION  BY toYYYYMM(create_time)
ORDER BY (id, create_time)
SETTINGS index_granularity = 8192;

-- 插入数据
INSERT INTO xxx_table (list)  VALUES ([1, 2, 3]);

-- 查询 list包含1001的数据
select id,create_time,list  from xxx_table ARRAY  JOIN list  WHERE list  in (1)　　

 

插入与接收类型

clickhouse type	java type
Array(Int32)	List<Integer>