建表示例：

1. CREATE TABLE IF NOT EXISTS m2d_record (
   
2. id bigint COMMENT '自增主键',
   
3. vday string COMMENT '日期',
   
4. phone string COMMENT '用户手机号',
   
5. channel string COMMENT '推广渠道(一级推广_二级推广)',
   
6. name string COMMENT '漏斗步骤',
   
7. update_time string COMMENT '更新时间'
   
8. ) COMMENT '商推司明细表'
   
9. PARTITIONED BY (`dt` string)
   
10. ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
    
11. STORED AS textfile;

复制代码

建表示例：

1. CREATE TABLE IF NOT EXISTS m2d_record (
   
2. id bigint COMMENT '自增主键',
   
3. vday string COMMENT '日期',
   
4. phone string COMMENT '用户手机号',
   
5. channel string COMMENT '推广渠道(一级推广_二级推广)',
   
6. name string COMMENT '漏斗步骤',
   
7. update_time string COMMENT '更新时间'
   
8. ) COMMENT '商推司明细表'
   
9. PARTITIONED BY (`dt` string)
   
10. ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'
    
11. STORED AS textfile;

复制代码