clickhouse
孩子加油孩子
我不怕千万人阻挡,只怕自己投降
展开
-
clickhouse 行列转换
将数组的每个元素都拆分成多个行值:arrayJoin(splitByChar(':',cast( tmp as String)) as src)再将t 列切分成一个数组,通过 splitByChar(':',cast( tmp as String)) as src。先把多个列拼接成一列 t: concat('1','_', m1,':' '2','_','m2') as t。原创 2023-02-23 16:35:55 · 2108 阅读 · 0 评论 -
clickhouse 操作报错
SQL 错误 [62]: ClickHouse exception, code: 62, host: 172.22.243.102, port: 8123; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 3499 (line 70, col 1): COMMENT '全景机柜信息中间表-包括特殊机房(香山同济)'. Expected one of: INTO OUTFILE, SETTINGS, FOR原创 2022-07-04 17:12:45 · 6043 阅读 · 2 评论