3.维表层
中文含义
MYSQL表名
HIVE表名
商品分类表
nshop.category
dim_nshop.dim_pub_category
店铺表
nshop.supplier
dim_nshop.dim_pub_supplier
商品表
nshop.product
dim_nshop.dim_pub_product
页面布局表
nshop.page_dim
dim_nshop.dim_pub_page
通用字典表
nshop comm_dim
dim nshop dim pub comm
时间字典表
nshop.date_dim
dim_nshop.dim_pub_date
地区字典表
nshop.area_dim
dim_nshop.dim_pub_area
创建Hive库并进入： create database if not exists dim_nshop; use dim_nshop;
3.1 商品分类表:
CREATE TABLE
IF NOT EXISTS dim_nshop.dim_pub_category (
category_code string COMMENT '分类编码',
category_name string COMMENT '分类名称',
category_parent_id string COMMEN
