Hive建分区表语句

** 客户资料表（日） *************************************************************
CREATE TABLE ZB_DWD.DWD_D_CUS_AL_CUSTOMER_PROV
(MONTH_ID STRING,
PROV_ID STRING,
CUST_ID STRING,
UNITY_CUST_ID STRING,
CUST_TYPE STRING,
CUST_NAME STRING,
AREA_ID STRING,
AREA_ID_PROV STRING,
CITY_ID STRING,
CITY_ID_PROV STRING,
CUST_CATEGORY STRING,
CUST_CATEGORY_PROV STRING,
CUST_CLASS STRING,
CUST_STATE STRING,
DEVP_CHANNEL_ID STRING,
ATTR_CHANNEL_ID STRING,
BUSI_AREA_TYPE STRING,
BUSI_AREA_TYPE_PROV STRING,
COUNTRY_ID STRING,
CUST_BEGIN_DATE STRING,
CUST_END_DATE STRING,
IDENTITY_TYPE STRING,
IDENTITY_ID STRING,
START_DATE STRING,
END_DATE STRING,
IS_NAME_VALID STRING)
PARTITIONED BY(PART_ID STRING,DAY_ID STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
******************************************************************************

** 新增用户客户资料衍生信息（日） ********************************************
CREATE TABLE ZB_DWA.DWA_V_D_CUS_AL_USER_CUST_PROV
(MONTH_ID STRING,
PROV_ID STRING,
AREA_ID STRING,
CITY_ID STRING,
CUST_ID STRING,
USER_ID STRING,
IS_ADD_TYPE STRING,
CUST_NAME STRING,
CUST_TYPE STRING,
CUST_CATEGORY STRING,
CERT_TYPE STRING,
CERT_NO STRING,
CERT_ADDR STRING,
CUST_ADDR STRING,
ATTRIBUTE_VALUE STRING,
SERVICE_TYPE STRING,
IS_CARD STRING)
PARTITIONED BY(PART_ID STRING,DAY_ID STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
********************************************************************************

** 客户实名制表（日） **********************************************************
CREATE TABLE ZB_DWA.DWA_V_D_CUS_AL_RNS_THIN_PROV
(MONTH_ID STRING,
PROV_ID STRING,
AREA_ID STRING,
CITY_ID STRING,
CUST_ID STRING,
CERT_TYPE STRING,
CUST_CATEGORY STRING,
CUST_NAME_IS_NULL STRING,
CUST_NAME_IS_VALID STRING,
GC_CUST_NAME_IS_VALID STRING,
CERT_TYPE_IS_NULL STRING,
CERT_TYPE_IS_VALID STRING,
CERT_NO_IS_NULL STRING,
CERT_NO_IS_VALID STRING,
IS_18_CERT_NO_VALID STRING,
IS_15_CERT_NO_VALID STRING,
CERT_ADDR_IS_VALID STRING,
CERT_ADDR_IS_NULL STRING,
CONTACT_ADDR_IS_NULL STRING,
INSTALL_ADDR_IS_NULL STRING)
PARTITIONED BY(PART_ID STRING,DAY_ID STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
********************************************************************************

** 客户证件信息表（日） ********************************************************
CREATE TABLE ZB_DWD.DWD_D_CUS_AL_CERT_INFO_PROV
(MONTH_ID STRING,
PROV_ID STRING,
CUST_ID STRING,
CERT_TYPE STRING,
CERT_TYPE_PROV STRING,
CERT_NO STRING,
CERT_ADDR STRING,
IS_CERT_REAL STRING,
CERT_NO_NUMS DOUBLE,
CERT_LENGTH DOUBLE)
PARTITIONED BY(PART_ID STRING,DAY_ID STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
********************************************************************************

** 客户属性表（日） ************************************************************
CREATE TABLE ZB_DWD.DWD_D_CUS_AL_CUST_ATTR_PROV
(MONTH_ID STRING,
PROV_ID STRING,
CUST_ID STRING,
CUST_DEVICE STRING,
CUST_ADDR STRING,
OPERATOR STRING)
PARTITIONED BY(PART_ID STRING,DAY_ID STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
********************************************************************************

** 用户属性表（日） ************************************************************
CREATE TABLE ZB_DWD.DWD_D_PRD_AL_USER_ATTR_PROV
(MONTH_ID STRING,
PROV_ID STRING,
USER_ID STRING,
ATTRIBUTE_TYPE STRING,
ATTRIBUTE_VALUE STRING,
ATTR_EFFECT_TIME STRING,
ATTR_EXPIRE_TIME STRING,
IS_VALID STRING)
PARTITIONED BY(PART_ID STRING,DAY_ID STRING)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE;
********************************************************************************

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28520410/viewspace-1254218/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28520410/viewspace-1254218/