etl_adn_request_sdk_daily.sql 1.57 KB
USE dwh;
DROP TABLE IF EXISTS dwh.etl_adn_request_sdk_daily;
CREATE EXTERNAL TABLE dwh.etl_adn_request_sdk_daily
(
    device_id    string,
    device_type  string,
    platform     string,
    app_id       string,
    package_name string,
    update_date  string,
    model        string,
    brand        string,
    os_version   string,
    country      string,
    strategy     string,
    region       string,
    dev_tag      int
) 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/etl_adn_request_sdk_daily';

USE dwh;
DROP TABLE IF EXISTS dwh.etl_adn_request_sdk_unmatch;
CREATE EXTERNAL TABLE dwh.etl_adn_request_sdk_unmatch
(
    device_id    string,
    device_type  string,
    platform     string,
    app_id       string,
    package_name string,
    update_date  string,
    model        string,
    brand        string,
    os_version   string,
    country      string,
    strategy     string,
    region       string,
    dev_tag      int
) 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/etl_adn_request_sdk_unmatch';