思路:使用分区表,按照日期分区(年月日),将数据导入分区表。根据分区查询统计每日注册的人数。
建立分区表:
accountregister.sql
create table accountregister (
AppID string comment "应用ID",
GameID string comment "游戏ID",
ChildID string comment "子版本ID",
IP string comment "登录ID",
AccountID string comment "账号ID",
LogType string comment "日志类型",
LogTime int comment "日志时间",
PlatformChannelID string comment "渠道平台",
IDfa string comment "广告标识符",
AndroidID string comment "安卓标识符",
Mac string comment "MAC地址") comment "注册信息表" partitioned by(year string,month string,day string)
row format delimited fields terminated by "|";