create external table IF NOT EXISTS adv_struct_stock_week(
uv string,
freqflag int,
sectionid int,
areaid int,
province string,
city string,
frequence bigint,
stock bigint,
week int)
PARTITIONED BY(dt int)
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
location '/user/adlog/adv_struct_stock_week';
location 声明必须在最后,否则会有异常: