![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
clickhouse
z小丑八怪r
这个作者很懒,什么都没留下…
展开
-
clickhouse 案例 分析用户行为日志 流量分析 漏斗分析
hive端测试--hive端建表create table tb_log(log string)partitifirstd by (dt string);load data local inpath '/root/event.log' into table tb_log partition (dt='20201007');--解析json数据,并对数据进行预处理create table tb_ods_log asselectif(account='',deviceId,accoun原创 2020-12-08 22:07:41 · 1458 阅读 · 2 评论 -
clickhouse案例 连续N天登录
数据a,2017-02-05,200a,2017-02-06,300a,2017-02-07,200a,2017-02-08,400a,2017-02-10,600b,2017-02-05,200b,2017-02-06,300b,2017-02-08,200b,2017-02-09,400b,2017-02-10,600c,2017-01-31,200c,2017-02-01,300c,2017-02-02,200c,2017-02-03,400c,2017-02-10,60原创 2020-12-07 22:54:04 · 624 阅读 · 0 评论 -
clickhouse学习笔记(三)SummingMergeTree 数据导入方式 数组类型 导出数据 array join groupArray arrayEnumerate limit 分区表
1 SummingMergeTree将相同主键的所有的数据累加--建表,插入数据create table sum_mergetree(id Int8 ,name String ,cDate Date ,cost Float64 )engine=SummingMergeTree(cost)order by id partition by name ;insert into sum_mergetree values(1,'zss','2020-12-06',70);insert int原创 2020-12-07 22:12:22 · 1246 阅读 · 2 评论 -
clickhouse学习笔记(二)MergeTree家族引擎 集成引擎 函数
MergeTreecreate table tb_tree1(id String ,name String ,city String)engine = MergeTree primary key id order by id;插入数据insert into tb_tree1 values('id004','wb','HB'),('id005','DHT','HN'),('id006','ZXX','HLJ');insert into tb_tree1 values('id0原创 2020-12-05 17:26:58 · 999 阅读 · 0 评论 -
clickhouse学习笔记(一)日志引擎
启动service clickhouse-server startclickhouse-client -m– 数据库create database db_name ;use db_name ; 切换数据库 ;select currentDatabase() ;┌─currentDatabase()─┐│ db_doit19 │└───────────────────┘drop database db_doit19 ;– 建表– 数据类型Int8原创 2020-12-04 22:21:47 · 563 阅读 · 0 评论