注意:插入数据的时候,字段顺序需与创建分区表时的顺序一致。
#################创建分区表
drop table if exists default.rpt_customer_coupon_details_partition;
CREATE TABLE default.rpt_customer_coupon_details_partition (
`id` int,
`cname` string,
`cphone` string,
`ccity` string,
`couponid` int,
`couponname` string,
`accity` string,
`ctype` int,
`couponvalue` double ,
`duration` string ,
`pagename` string ,
`expired_at` string ,
`status` int ,
`minCost` double ,
`maxDiscount` double ,
`minPay` double ,
`created_at` string ,
`updated_at` string,
`source` string ,
`actionname` string ,
`carprice` double,
`taxiprice`