1.clickhouse中创建表
CREATE TABLE user_behavior_test (
user_id String,
item_id String,
category_id String,
behavior_type String,
time_stamp String
)ENGINE = MergeTree ORDER BY (user_id, item_id, time_stamp);
2.插入一下测试数据
准备数据如下:
1,2268318,2520377,pv,1511544070
1,2333346,2520771,pv,1511561733
1,2576651,149192,pv,1511572885
1,3830808,4181361,pv,1511593493
1,4365585,2520377,pv,1511596146
1,4606018,2735466,pv,1511616481
1,230380,411153,pv,1511644942
1,3827899,2920476,pv,1511713473
1,3745169,2891509,pv,1511725471
1,1531036,2920476,pv,1511733732
导入到user_behavior_test表
# clickhouse-client --query "INSERT INTO datasets.user_behavior_test FORMAT CSV" < /home/datasets/ub-10.csv --use