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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

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)　　<br><br><br>

 

插入与接收类型

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