随笔分类 -  clickhouse

实时数仓实践
摘要：微信基于 ClickHouse 的实时数仓实践 https://mp.weixin.qq.com/s/dxoU7S7hOK_PIBZp5OZTKA 阅读全文
posted @ 2022-09-23 15:53 tonggc1668 阅读(25) 评论(0) 推荐(0)
Mac编译ClickHouse
摘要：Mac OS 如何查看cpu支持的指令集？ https://www.isolves.com/it/rj/czxt/mac/2021-12-22/47644.html 在Mac OS X 10.15.6中安装ClickHouse https://blog.csdn.net/shufangreal/ar 阅读全文
posted @ 2022-06-28 17:51 tonggc1668 阅读(81) 评论(0) 推荐(0)
clickhouse参数
摘要：https://clickhouse.com/docs/en/operations/settings/settings/#settings-join_algorithm https://clickhouse.com/docs/en/operations/server-configuration-pa 阅读全文
posted @ 2022-04-01 17:46 tonggc1668 阅读(124) 评论(0) 推荐(0)
clickhouse-server.service
摘要：cat /etc/systemd/system/clickhouse-server.service[Unit]Description=ClickHouse Server (analytic DBMS for big data)Requires=network-online.targetAfter=n 阅读全文
posted @ 2022-02-21 10:11 tonggc1668 阅读(790) 评论(0) 推荐(0)
maven shade plugin
摘要：maven 常用插件之shade https://www.jianshu.com/p/1bbb317b55ee Maven shade for spring boot https://my.oschina.net/u/732556/blog/1545821 使用maven-shade-plugin打 阅读全文
posted @ 2021-07-12 11:50 tonggc1668 阅读(312) 评论(0) 推荐(0)
clickhouse_sql
摘要：/data/app/clickhouse2/bin/clickhouse-client --multiquery -h 127.0.0.1 --port 19000 --user default --password eb22d98eaf028b1ca5c36548193d604a echo "se 阅读全文
posted @ 2021-07-08 17:01 tonggc1668 阅读(188) 评论(0) 推荐(0)
clickhouse system.parts
摘要：SELECT * from system.parts where database = 'shard1' and table = 'upsf_ods_upb_tbl_market_activity_log_info_ulsp_replica';--shard1 shard2 shard3SELECT 阅读全文
posted @ 2021-07-08 16:56 tonggc1668 阅读(440) 评论(0) 推荐(0)
文件换行输入和清空
摘要：cat > /etc/security/limits.conf<< EOF* soft nproc 16384* hard nproc 16384* soft nofile 1048576* hard nofile 1048576* soft stack 10240* hard stack 3276 阅读全文
posted @ 2021-06-30 00:34 tonggc1668 阅读(60) 评论(0) 推荐(0)
clickhouse
摘要：分区表达式 按小时分区 formatDateTime(toDateTime(subString(logTime,1,19)),'%F %H') 按天分区 toDate(_cw_raw_time/1000) toDate(subString(transDt,1,10)) 单机无副本 CREATE TA 阅读全文
posted @ 2021-06-25 20:38 tonggc1668 阅读(475) 评论(0) 推荐(0)
clickhouse原理
摘要：那些年我们踩过的一些坑之 ClickHouse https://zhuanlan.zhihu.com/p/345354936 ClickHouse MergeTree变得更像LSM Tree了？——Polymorphic Parts特性浅析 https://www.jianshu.com/p/f38 阅读全文
posted @ 2021-06-03 11:22 tonggc1668 阅读(106) 评论(0) 推荐(0)