CREATE TABLE `dw_d_provi_bs`(

  `provi_wid` decimal(22,0), 

  `provi_id` string)

PARTITIONED BY ( 

  `p_bu_id` string, 

  `p_cate_tree_id` string)

ROW FORMAT SERDE 

  'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' 

WITH SERDEPROPERTIES ( 

  'field.delim'='\u0001', 

  'serialization.format'='\u0001') 

STORED AS INPUTFORMAT 

  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' 

OUTPUTFORMAT 

  'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat'

LOCATION

  'hdfs://wjbigdpprd01:8020/user/hive/warehouse/bidw.db/dw_d_provi_bs'

TBLPROPERTIES (

  'transient_lastDdlTime'='1576548908')

WARN: The method class org.apache.commons.logging.impl.SLF4JLogFactory#release() was invoked.

WARN: Please see http://www.slf4j.org/codes.html#release for an explanation.;

--=========== db: bidw , table: dw_d_provi_ex ===========

期望：将 ROW FORMAT SERDE至 ===========字符串替换为

stored as parquet

如上