> cd /home/work/warehouse_goods_order
> vi dwd_shopmall_init.sh

#!/bin/bash
# dwd层数据库和表初始化，只需要执行一次

hive -e "
create database if not exists dwd_shopmall;

create external table if not exists dwd_shopmall.dwd_user (
    id              bigint,
    username        string,
    gender          tinyint,
    birthday        string,
    email           string,
    mobile          string,
    createtime      string,
    disabled        tinyint
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/user/';

create external table if not exists dwd_shopmall.dwd_user_addr (
    id              bigint,
    userid          bigint,
    addrname        string,
    isdefault       tinyint,
    username        string,
    mobile          string
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/user_addr/';

create external table if not exists dwd_shopmall.dwd_category (
    id              int,
    parentids       string,
    name            string,
    level           int,
    createtime      string
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/category/';

create external table if not exists dwd_shopmall.dwd_goods_info (
    id              bigint,
    name            string,
    desc            string,
    price           double,
    categoryid      int,
    createtime      string
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/goods_info/';

create external table if not exists dwd_shopmall.dwd_payment (
    id              bigint,
    orderid         bigint,
    tradeno         string,
    money           double,
    type            int,
    createtime      string
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/payment/';

create external table if not exists dwd_shopmall.dwd_order (
    id              bigint,
    userid          bigint,
    money           double,
    type            int,
    status          int,
    payid           bigint,
    createtime      string,
    updatetime      string
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/order/';

create external table if not exists dwd_shopmall.dwd_orderitem (
    orderid         bigint,
    goodsid         bigint,
    amount          int,
    price           double,
    createtime      string
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/orderitem/';
"

> mkdir -p /home/work/warehouse_user_action
> cd /home/work/warehouse_user_action
> vi dwd_shopmall_init.sh

#!/bin/bash
# dwd层数据库和表初始化脚本，只需执行一次

hive -e "
create database if not exists dwd_shopmall;

create external table if not exists dwd_shopmall.dwd_app_open (
    uid         bigint,
    did         string,
    platform    tinyint,
    ver         string,
    code        string,
    net         tinyint,
    brand       string,
    model       string,
    display     string,
    os          string,
    timestamp   bigint,
    adstatus    tinyint,
    loadingtime bigint
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/app_open/';

create external table if not exists dwd_shopmall.dwd_goods_click (
    uid         bigint,
    did         string,
    platform    tinyint,
    ver         string,
    code        string,
    net         tinyint,
    brand       string,
    model       string,
    display     string,
    os          string,
    timestamp   bigint,
    goodsid     bigint,
    location    tinyint
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/goods_click/';

create external table if not exists dwd_shopmall.dwd_goods_item (
    uid         bigint,
    did         string,
    platform    tinyint,
    ver         string,
    code        string,
    net         tinyint,
    brand       string,
    model       string,
    display     string,
    os          string,
    timestamp   bigint,
    goodsid     bigint,
    staytime    bigint,
    loadingtime bigint
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/goods_item/';

create external table if not exists dwd_shopmall.dwd_goods_list (
    uid         bigint,
    did         string,
    platform    tinyint,
    ver         string,
    code        string,
    net         tinyint,
    brand       string,
    model       string,
    display     string,
    os          string,
    timestamp   bigint,
    loadingtime bigint,
    loadingtype tinyint,
    goodsnum    tinyint
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/goods_list/';

create external table if not exists dwd_shopmall.dwd_app_collapse (
    uid         bigint,
    did         string,
    platform    tinyint,
    ver         string,
    code        string,
    net         tinyint,
    brand       string,
    model       string,
    display     string,
    os          string,
    timestamp   bigint
) partitioned by(dt string)
  row format delimited
  fields terminated by '\t'
  location 'hdfs://server01:9000/data/dwd/app_collapse/';
"