pigdance commented on issue #5696:
URL:
https://github.com/apache/incubator-doris/issues/5696#issuecomment-826209438
> show me your create table stmt？
CREATE TABLE `test` (
`pay_trade_id` varchar(192) NULL COMMENT "",
`pday` date NULL COMMENT "parttime",
`third_pay_user_name` varchar(384) NULL COMMENT "",
`supplier_pid` varchar(192) NULL COMMENT "",
`third_result_msg` varchar(765) NULL COMMENT "",
`ac_deduction_money` int(11) NULL COMMENT "",
`out_shop_id` varchar(192) NULL COMMENT "",
`trade_id` varchar(192) NULL COMMENT "",
`isv_merchant_id` varchar(192) NULL COMMENT "",
`undiscountable_money` int(11) NULL COMMENT "",
`receipt_amount` int(11) NULL COMMENT "",
`buyer_pay_amount` int(11) NULL COMMENT "",
`third_trade_no` varchar(384) NULL COMMENT "",
`notify_time` bigint(20) NULL COMMENT "",
`refund_status` tinyint(4) NULL COMMENT "",
`create_time` bigint(20) NULL COMMENT "",
`expire_time` int(11) NULL COMMENT "",
`discountable_money` int(11) NULL COMMENT "",
`notify_status` tinyint(4) NULL COMMENT "",
`pay_time` bigint(20) NULL COMMENT "",
`shop_id` varchar(384) NULL COMMENT "",
`user_id` int(11) NULL COMMENT "",
`isv_merchant_code` varchar(765) NULL COMMENT "",
`trade_no` varchar(192) NULL COMMENT "",
`pay_channel` tinyint(4) NULL COMMENT "",
`extension10` varchar(765) NULL COMMENT "",
`supplier_id` varchar(192) NULL COMMENT "",
`third_pay_user_id` varchar(384) NULL COMMENT "",
`status` tinyint(4) NULL COMMENT "",
`es` bigint(20) NULL COMMENT "binlogTime"
) ENGINE=OLAP
UNIQUE KEY(`pay_trade_id`, `pday`)
COMMENT "OLAP"
PARTITION BY RANGE(`pday`)
(PARTITION p1 VALUES [('0000-01-01'), ('2021-04-14')),
PARTITION p20210414 VALUES [('2021-04-14'), ('2021-04-15')),
PARTITION p20210415 VALUES [('2021-04-15'), ('2021-04-16')),
PARTITION p20210416 VALUES [('2021-04-16'), ('2021-04-17')),
PARTITION p20210417 VALUES [('2021-04-17'), ('2021-04-18')),
PARTITION p20210418 VALUES [('2021-04-18'), ('2021-04-19')),
PARTITION p20210419 VALUES [('2021-04-19'), ('2021-04-20')),
PARTITION p20210420 VALUES [('2021-04-20'), ('2021-04-21')),
PARTITION p20210421 VALUES [('2021-04-21'), ('2021-04-22')),
PARTITION p20210422 VALUES [('2021-04-22'), ('2021-04-23')),
PARTITION p20210423 VALUES [('2021-04-23'), ('2021-04-24')),
PARTITION p20210424 VALUES [('2021-04-24'), ('2021-04-25')),
PARTITION p20210425 VALUES [('2021-04-25'), ('2021-04-26')),
PARTITION p20210426 VALUES [('2021-04-26'), ('2021-04-27')),
PARTITION p20210427 VALUES [('2021-04-27'), ('2021-04-28')),
PARTITION p20210428 VALUES [('2021-04-28'), ('2021-04-29')))
DISTRIBUTED BY HASH(`pay_trade_id`, `pday`) BUCKETS 10
PROPERTIES (
"replication_num" = "2",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" =
"sun.util.calendar.ZoneInfo[id="Asia/Shanghai",offset=28800000,dstSavings=0,useDaylight=false,transitions=19,lastRule=null]",
"dynamic_partition.start" = "-30",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.replication_num" = "2",
"dynamic_partition.buckets" = "8",
"in_memory" = "false",
"storage_format" = "V2"
); |
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
