文章目录
clickhouse统计常用函数
1.uniqExact
uniqExact 去重, count(DISTINCT x) 就是uniqExact函数
SELECT count(distinct(customer_id)) FROM trade_ch WHERE user_id =$user_id;
SELECT uniqExact( customer_id) FROM trade_ch where user_id =$user_id;
2.array join
array join 将数组拆开,一行数据变成多行数据
SELECT * FROM trade_ch WHERE user_id =$user_id AND id=$id;
SELECT * FROM trade_ch final array join orders.item_num , orders.price WHERE id=$id;
3.flatten
flatten 拍平 多维数组变为一维数组
示例: [[1, 2, 3], [4, 5]] => [1, 2, 3, 4, 5]
SELECT arrayFlatten([[1, 2, 3], [4, 5]]);
4.arrayEnumerateDense
arrayEnumerateDense 返回元素所在的位置 例如:
select [98,100,