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

建表，导入数据

create table shop(
name String,
ctime Date,
cost Float64
)
engine=MergeTree
primary key (name,ctime)
order by (name,ctime);

cat shop.csv | clickhouse-client -q 'insert into shop FORMAT CSV';

select 
name,groupArray(ctime) arr,
arrayEnumerate(arr)  arr_index
from 
shop
group by name
┌─name─┬─arr─────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬─arr_index──────────────┐
│ b    │ ['2017-02-05','2017-02-06','2017-02-08','2017-02-09','2017-02-10']                                                                  │ [1,2,3,4,5]            │
│ c    │ ['2017-01-31','2017-02-01','2017-02-02',