DROP TABLE IF EXISTS app_wms_data_clean_bs_pack;
CREATE EXTERNAL TABLE app_wms_data_clean_bs_pack(
stat_date string comment '统计日期',
GOODS_NO string COMMENT 'sku',
PACKCODE string COMMENT '包装',
PACK_NAME string COMMENT '名称',
DESCRIPTION string COMMENT '描述',
PACKING_UNIT string COMMENT '包装的单位',
PACKING_QTY string COMMENT '包装件数',
PACKING_ORDER string COMMENT '包装的排序',
LENGTH string COMMENT '长',
WIDTH string COMMENT '宽',
HEIGHT string COMMENT '高',
WIDTHUOM string COMMENT '宽单位',
HEIGHTUOM string COMMENT '高单位',
LENGTHUOM string COMMENT '长单位',
WEIGHT string COMMENT '重量',
WEIGHTUOM string COMMENT '重量单位',
CREATE_TIME string COMMENT '创建时间',
UPDATE_TIME string COMMENT '更新时间',
WAREHOUSE_NO string COMMENT '库房编号',
CREATE_USER string COMMENT '创建人',
UPDATE_USER string COMMENT '修改人',
ORG_NO string COMMENT '机构编号',
DISTRIBUTE_NO string COMMENT '配送中心',
YN string COMMENT '删除标记',
PACKING_KEY string COMMENT ''
)
COMMENT '包装'
partitioned BY (dt string)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
WITH SERDEPROPERTIES (
'field.delim' = '\t')
STORED AS INPUTFORMAT "com.hadoop.mapred.DeprecatedLzoTextInputFormat"
OUTPUTFORMAT "org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat";