ClickHouse 习题练习 （连续N天的登录记录）

a,2017-02-05,200
a,2017-02-06,300
a,2017-02-07,200
a,2017-02-08,400
a,2017-02-10,600
b,2017-02-05,200
b,2017-02-06,300
b,2017-02-08,200
b,2017-02-09,400
b,2017-02-10,600
c,2017-01-31,200
c,2017-02-01,300
c,2017-02-02,200
c,2017-02-03,400
c,2017-02-10,600
a,2017-03-01,200
a,2017-03-02,300
a,2017-03-03,200
a,2017-03-04,400
a,2017-03-05,600

求连续N天的销售记录

一 先建一个 ClickHouse 表

create table  
tb_shop(name String , ctime Date ,money Float64) 
engine=MergeTree   --->  引擎
primary key (name,ctime)  ----> 主键 
order by (name,ctime) ;  ---->  分组

二 导入数据

cat  shop.csv | clickhouse-client