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;