Hive建表
建表示例:
CREATE TABLE IF NOT EXISTS m2d_record (
id bigint COMMENT '自增主键',
vday string COMMENT '日期',
phone string COMMENT '用户手机号',
channel string COMMENT '推广渠道(一级推广_二级推广)',
name string COMMENT '漏斗步骤',
update_time string COMMENT '更新时间'
) COMMENT '商推司明细表'
PARTITIONED BY (`dt` string)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
STORED AS textfile;
页:
[1]