开发者学堂课程【新电商大数据平台2020最新课程：电商项目之交易类指标统计表分析】学习笔记，与课程紧密联系，让用户快速学习知识。
课程地址：https://developer.aliyun.com/learning/course/640/detail/10568
电商项目之交易类指标统计表分析
交易类指标表4X [示例] [ADS]
create external table if not exists ads_ nshop. ads_nshop_busi_stat(
customer_ gender TINYINT COMMENT "性别: 1男0女"，
age_ range string COMMENT ‘年龄段’，
customer_ area_ code string COMMENT ” 所在地区，
category_ type string COMMENT " 商品类别’，
Supplier_type string COMMENT ‘店铺类别"，
busi_ succ_orders int comment " 交易成功订单数’，
busi_ succ_ anounts int comment ‘交易成功金额"，
Busi_succ_users int comment ‘交易成功买家数 ，
busi_ succ_ products int comment ‘交易成功商品数，
busi_ fail_orders int comment '交易失败订单数"，
busi_ fail_ amounts int comment ‘交易失败金额'
) partitioned by (bdp_ day string)
stored as parquet
location ' /data/nshop/ ads/operation/ads_nshop_busi_ stat/'
