dsp_profile_total.sql 667 Bytes
Newer Older
wang-jinfeng committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
USE dwh;
CREATE EXTERNAL TABLE dwh.`dsp_profile_total`(
    device_id string,
    device_type string,
    platform string,
    maker string,
    model string,
    os_version string,
    country string,
    birthday string,
    gender string,
    dmp_time string
)PARTITIONED BY (
    dt string
) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT
    'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
OUTPUTFORMAT
    'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
LOCATION 's3://mob-emr-test/dataplatform/DataWareHouse/data/dwh/dsp_profile_total';

alter table dwh.dmp_interest_tag add columns(ext_data string,update_date string);