Hive建表

CREATE EXTERNAL TABLE dwh_app_logins_push_status (
    uid STRING,
    user_id STRING,
    euid STRING,
    imei STRING,
    idfa STRING,
    mac STRING,
    client STRING,
    day_now_diff_one_before STRING,
    day_one_diff_two_before STRING,
    rl_last STRING,
    rl STRING
)
PARTITIONED BY(p_day BIGINT)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
STORED AS RCFILE LOCATION '/user/hive/warehouse/dg/bigtables/dwh_app_logins_push_status';`