Clickhouse groupArray/groupUniqArray/arrayJoin/splitByChar
行列转置一般由由行转为列,或者由列转为行。CREATE TABLE datasets.t_city( `province` String, `city` String, `createtime` DateTime, `city_level` Int8)ENGINE = MergeTree()ORDER BY provinceSETTINGS index_granularity = 8192; insert into t_city values.