创建外部表(分区表)语句:
DROP TABLE IF EXISTS dw.dim_area_info;
CREATE EXTERNAL TABLE IF NOT EXISTS dw.dim_area_info
(
province_code string comment '省code',
province_desc string comment '省',
city_code
创建外部表(分区表)语句:
DROP TABLE IF EXISTS dw.dim_area_info;
CREATE EXTERNAL TABLE IF NOT EXISTS dw.dim_area_info
(
province_code string comment '省code',
province_desc string comment '省',
city_code