#***************************
#** 功能描述:订单宽表模型开发
#***************************
–订单主要信息表BDM层
create database if not exists bdm;
create external table if not exists bdm.itcast_bdm_order(
order_id string, --订单ID
order_no string, --订单号
order_date string, --订单日期
user_id string, --用户ID
user_name string, --登录名
order_money double, --订单金额
order_type string, --订单类型
order_status string, --订单状态
pay_status string, --支付状态
pay_type string, --支付方式 1、在线支付,2、货到付款
order_source string, --订单来源
update_time timestamp --订单更新时间
) partitioned by (dt string)
row format delimited fields terminated by ‘,’
lines terminated by ‘\n’
location ‘/business/itcast_bdm_order’;
alter table bdm.itcast_bdm_order add partition (dt=‘2017-01-01’) location ‘/business/itcast_bdm_order/dt=2017-01-01’;
hdfs dfs -put /root/source_data/itcast_bdm_order.txt /business/itcas