03、购物车订单表.sql

------购物车订单表BDM层
create database if not exists bdm;
create external table if not exists bdm.itcast_bdm_order_cart(
id bigint,–ID
session_id string,–sessionID
user_id string,–用户ID
goods_id string,–商品ID
goods_num bigint,–商品数量
add_time string,–商品加入时间

cancle_time string,–商品取消时间
sumbit_time string,–商品提交时间

dw_date timestamp
) partitioned by (dt string)
row format delimited fields terminated by ‘,’
lines terminated by ‘\n’
location ‘/business/itcast_bdm_order_cart’;

alter table bdm.itcast_bdm_order_cart add partition (dt=‘2017-01-01’) location ‘/business/itcast_bdm_order_cart/dt=2017-01-01’;
hdfs dfs -put /root/source_data/itcast_bdm_order_cart.txt /business/itcast_bdm_order_cart/dt=2017-01-01

------购物车订单表FDM层
create database if not exists fdm;
create table if not exists fdm.itcast_fdm_order_cart(
id bigint,–ID
session_id string,–sessionID<