hive 建表语句

drop table if exists o_wtssj_lgqwtlyj_v_maintenanceprice_cur;

create table if not exists o_wtssj_lgqwtlyj_v_maintenanceprice_cur (
  mplid string comment '价格清单id，主键',
  mplname string comment '维修名称',
  mpltype string comment '维修类型',
  mplunit string comment '维修单位',
  mplunitprice decimal(38) comment '维修单价',
  timeflag string comment '',
  etl_dt string comment 'etl日期',
  is_reload string comment '重跑标识',
  sys_reload_dt string comment '重跑时间',
  data_source_id string comment '数据来源',
dses_uuid string comment '代理主键')
comment '维修内容价格清单'
partitioned by (dat_dt string comment '数据日期')
row format delimited
fields terminated by '\001'
lines terminated by '\002\n'
stored as textfile;