Skip to content

Commit 1a8cb05

Browse files
committed
[case]add JFKJ case (apache#31)
* add JFKJ case
1 parent dfc0017 commit 1a8cb05

6 files changed

Lines changed: 406 additions & 0 deletions

File tree

Lines changed: 4 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,4 @@
1+
-- This file is automatically generated. You should know what you did if you want to edit this
2+
-- !q01 --
3+
200
4+
Lines changed: 48 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,48 @@
1+
CREATE TABLE `gw_dwd_guardpower_detail`
2+
(
3+
`wfid` varchar(30) NOT NULL COMMENT "风场id",
4+
`wtid` varchar(20) NOT NULL COMMENT "设备id",
5+
`densityval` decimal(12, 4) NOT NULL COMMENT "空气密度",
6+
`windspeed` decimal(12, 4) NOT NULL COMMENT "担保功率",
7+
`modifytime` datetime NULL COMMENT "修改时间",
8+
`guardpowerdetail_id` bigint(20) NOT NULL COMMENT "gw_ods_guardpowerdetail表id",
9+
`tbpower` double NOT NULL COMMENT "空气密度",
10+
`guardpowerid` bigint(20) NOT NULL COMMENT "担保功率曲线id",
11+
`name` varchar(255) NOT NULL COMMENT "功率曲线名称",
12+
`remark` varchar(255) NULL COMMENT "备注",
13+
`wtpowercurve_id` bigint(20) NOT NULL COMMENT "gw_ods_wtpowercurve表id",
14+
`id` bigint(20) NULL COMMENT "主键"
15+
) ENGINE=OLAP
16+
UNIQUE KEY(`wfid`, `wtid`, `densityval`, `windspeed`, `modifytime`)
17+
COMMENT "担保功率曲线明细表"
18+
PARTITION BY RANGE(`modifytime`)
19+
(PARTITION p20220101 VALUES [('0000-01-01 00:00:00'), ('2022-01-01 00:00:00')),
20+
PARTITION p202201 VALUES [('2022-01-01 00:00:00'), ('2022-02-01 00:00:00')),
21+
PARTITION p202202 VALUES [('2022-02-01 00:00:00'), ('2022-03-01 00:00:00')),
22+
PARTITION p202203 VALUES [('2022-03-01 00:00:00'), ('2022-04-01 00:00:00')),
23+
PARTITION p202204 VALUES [('2022-04-01 00:00:00'), ('2022-05-01 00:00:00')),
24+
PARTITION p202205 VALUES [('2022-05-01 00:00:00'), ('2022-06-01 00:00:00')),
25+
PARTITION p202206 VALUES [('2022-06-01 00:00:00'), ('2022-07-01 00:00:00')),
26+
PARTITION p202207 VALUES [('2022-07-01 00:00:00'), ('2022-08-01 00:00:00')),
27+
PARTITION p202208 VALUES [('2022-08-01 00:00:00'), ('2022-09-01 00:00:00')),
28+
PARTITION p202209 VALUES [('2022-09-01 00:00:00'), ('2022-10-01 00:00:00')))
29+
DISTRIBUTED BY HASH(`wfid`) BUCKETS 10
30+
PROPERTIES (
31+
"replication_allocation" = "tag.location.default: 1",
32+
"dynamic_partition.enable" = "true",
33+
"dynamic_partition.time_unit" = "MONTH",
34+
"dynamic_partition.time_zone" = "America/New_York",
35+
"dynamic_partition.start" = "-2147483648",
36+
"dynamic_partition.end" = "2",
37+
"dynamic_partition.prefix" = "p",
38+
"dynamic_partition.replication_allocation" = "tag.location.default: 1",
39+
"dynamic_partition.buckets" = "8",
40+
"dynamic_partition.create_history_partition" = "true",
41+
"dynamic_partition.history_partition_num" = "50",
42+
"dynamic_partition.hot_partition_num" = "0",
43+
"dynamic_partition.reserved_history_periods" = "NULL",
44+
"dynamic_partition.start_day_of_month" = "1",
45+
"in_memory" = "false",
46+
"storage_format" = "V2"
47+
);
48+
Lines changed: 227 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,227 @@
1+
CREATE TABLE `gw_dwd_powercurve`
2+
(
3+
`wtid` varchar(100) NOT NULL COMMENT "风机id",
4+
`wfid` varchar(100) NOT NULL COMMENT "电场id",
5+
`rectime` datetime NOT NULL COMMENT "发生时间",
6+
`windspeed` decimal(10, 4) NULL COMMENT "实测风速",
7+
`tbpower` decimal(10, 4) NULL COMMENT "实测功率",
8+
`localwindspeed` decimal(10, 4) NULL COMMENT "当地空气密度下的风速",
9+
`localpower` decimal(10, 4) NULL COMMENT "当地空气密度下的功率",
10+
`stdwindspeed` decimal(10, 4) NULL COMMENT "标准空气密度下的风速",
11+
`stdpower` decimal(10, 4) NULL COMMENT "标准空气密度下的功率",
12+
`stdspeedarea` int(11) NULL COMMENT "标准空气密度下的风速的区间号(0.5步长)",
13+
`totalnum` int(11) NULL COMMENT "数据总条数",
14+
`availnum` int(11) NULL COMMENT "数据有效条数",
15+
`id` bigint(20) NULL COMMENT "主键"
16+
) ENGINE=OLAP
17+
UNIQUE KEY(`wtid`, `wfid`, `rectime`)
18+
COMMENT "功率曲线表"
19+
PARTITION BY RANGE(`rectime`)
20+
(PARTITION p20220101 VALUES [('0000-01-01 00:00:00'), ('2022-01-01 00:00:00')),
21+
PARTITION p20220102 VALUES [('2022-01-02 00:00:00'), ('2022-01-03 00:00:00')),
22+
PARTITION p20220103 VALUES [('2022-01-03 00:00:00'), ('2022-01-04 00:00:00')),
23+
PARTITION p20220104 VALUES [('2022-01-04 00:00:00'), ('2022-01-05 00:00:00')),
24+
PARTITION p20220105 VALUES [('2022-01-05 00:00:00'), ('2022-01-06 00:00:00')),
25+
PARTITION p20220106 VALUES [('2022-01-06 00:00:00'), ('2022-01-07 00:00:00')),
26+
PARTITION p20220107 VALUES [('2022-01-07 00:00:00'), ('2022-01-08 00:00:00')),
27+
PARTITION p20220108 VALUES [('2022-01-08 00:00:00'), ('2022-01-09 00:00:00')),
28+
PARTITION p20220109 VALUES [('2022-01-09 00:00:00'), ('2022-01-10 00:00:00')),
29+
PARTITION p20220110 VALUES [('2022-01-10 00:00:00'), ('2022-01-11 00:00:00')),
30+
PARTITION p20220111 VALUES [('2022-01-11 00:00:00'), ('2022-01-12 00:00:00')),
31+
PARTITION p20220112 VALUES [('2022-01-12 00:00:00'), ('2022-01-13 00:00:00')),
32+
PARTITION p20220113 VALUES [('2022-01-13 00:00:00'), ('2022-01-14 00:00:00')),
33+
PARTITION p20220114 VALUES [('2022-01-14 00:00:00'), ('2022-01-15 00:00:00')),
34+
PARTITION p20220115 VALUES [('2022-01-15 00:00:00'), ('2022-01-16 00:00:00')),
35+
PARTITION p20220116 VALUES [('2022-01-16 00:00:00'), ('2022-01-17 00:00:00')),
36+
PARTITION p20220117 VALUES [('2022-01-17 00:00:00'), ('2022-01-18 00:00:00')),
37+
PARTITION p20220118 VALUES [('2022-01-18 00:00:00'), ('2022-01-19 00:00:00')),
38+
PARTITION p20220119 VALUES [('2022-01-19 00:00:00'), ('2022-01-20 00:00:00')),
39+
PARTITION p20220120 VALUES [('2022-01-20 00:00:00'), ('2022-01-21 00:00:00')),
40+
PARTITION p20220121 VALUES [('2022-01-21 00:00:00'), ('2022-01-22 00:00:00')),
41+
PARTITION p20220122 VALUES [('2022-01-22 00:00:00'), ('2022-01-23 00:00:00')),
42+
PARTITION p20220123 VALUES [('2022-01-23 00:00:00'), ('2022-01-24 00:00:00')),
43+
PARTITION p20220124 VALUES [('2022-01-24 00:00:00'), ('2022-01-25 00:00:00')),
44+
PARTITION p20220125 VALUES [('2022-01-25 00:00:00'), ('2022-01-26 00:00:00')),
45+
PARTITION p20220126 VALUES [('2022-01-26 00:00:00'), ('2022-01-27 00:00:00')),
46+
PARTITION p20220127 VALUES [('2022-01-27 00:00:00'), ('2022-01-28 00:00:00')),
47+
PARTITION p20220128 VALUES [('2022-01-28 00:00:00'), ('2022-01-29 00:00:00')),
48+
PARTITION p20220129 VALUES [('2022-01-29 00:00:00'), ('2022-01-30 00:00:00')),
49+
PARTITION p20220130 VALUES [('2022-01-30 00:00:00'), ('2022-01-31 00:00:00')),
50+
PARTITION p20220131 VALUES [('2022-01-31 00:00:00'), ('2022-02-01 00:00:00')),
51+
PARTITION p20220201 VALUES [('2022-02-01 00:00:00'), ('2022-02-02 00:00:00')),
52+
PARTITION p20220202 VALUES [('2022-02-02 00:00:00'), ('2022-02-03 00:00:00')),
53+
PARTITION p20220203 VALUES [('2022-02-03 00:00:00'), ('2022-02-04 00:00:00')),
54+
PARTITION p20220204 VALUES [('2022-02-04 00:00:00'), ('2022-02-05 00:00:00')),
55+
PARTITION p20220205 VALUES [('2022-02-05 00:00:00'), ('2022-02-06 00:00:00')),
56+
PARTITION p20220206 VALUES [('2022-02-06 00:00:00'), ('2022-02-07 00:00:00')),
57+
PARTITION p20220207 VALUES [('2022-02-07 00:00:00'), ('2022-02-08 00:00:00')),
58+
PARTITION p20220208 VALUES [('2022-02-08 00:00:00'), ('2022-02-09 00:00:00')),
59+
PARTITION p20220209 VALUES [('2022-02-09 00:00:00'), ('2022-02-10 00:00:00')),
60+
PARTITION p20220210 VALUES [('2022-02-10 00:00:00'), ('2022-02-11 00:00:00')),
61+
PARTITION p20220211 VALUES [('2022-02-11 00:00:00'), ('2022-02-12 00:00:00')),
62+
PARTITION p20220212 VALUES [('2022-02-12 00:00:00'), ('2022-02-13 00:00:00')),
63+
PARTITION p20220213 VALUES [('2022-02-13 00:00:00'), ('2022-02-14 00:00:00')),
64+
PARTITION p20220214 VALUES [('2022-02-14 00:00:00'), ('2022-02-15 00:00:00')),
65+
PARTITION p20220215 VALUES [('2022-02-15 00:00:00'), ('2022-02-16 00:00:00')),
66+
PARTITION p20220216 VALUES [('2022-02-16 00:00:00'), ('2022-02-17 00:00:00')),
67+
PARTITION p20220217 VALUES [('2022-02-17 00:00:00'), ('2022-02-18 00:00:00')),
68+
PARTITION p20220218 VALUES [('2022-02-18 00:00:00'), ('2022-02-19 00:00:00')),
69+
PARTITION p20220219 VALUES [('2022-02-19 00:00:00'), ('2022-02-20 00:00:00')),
70+
PARTITION p20220220 VALUES [('2022-02-20 00:00:00'), ('2022-02-21 00:00:00')),
71+
PARTITION p20220221 VALUES [('2022-02-21 00:00:00'), ('2022-02-22 00:00:00')),
72+
PARTITION p20220222 VALUES [('2022-02-22 00:00:00'), ('2022-02-23 00:00:00')),
73+
PARTITION p20220223 VALUES [('2022-02-23 00:00:00'), ('2022-02-24 00:00:00')),
74+
PARTITION p20220224 VALUES [('2022-02-24 00:00:00'), ('2022-02-25 00:00:00')),
75+
PARTITION p20220225 VALUES [('2022-02-25 00:00:00'), ('2022-02-26 00:00:00')),
76+
PARTITION p20220226 VALUES [('2022-02-26 00:00:00'), ('2022-02-27 00:00:00')),
77+
PARTITION p20220227 VALUES [('2022-02-27 00:00:00'), ('2022-02-28 00:00:00')),
78+
PARTITION p20220228 VALUES [('2022-02-28 00:00:00'), ('2022-03-01 00:00:00')),
79+
PARTITION p20220301 VALUES [('2022-03-01 00:00:00'), ('2022-03-02 00:00:00')),
80+
PARTITION p20220302 VALUES [('2022-03-02 00:00:00'), ('2022-03-03 00:00:00')),
81+
PARTITION p20220303 VALUES [('2022-03-03 00:00:00'), ('2022-03-04 00:00:00')),
82+
PARTITION p20220304 VALUES [('2022-03-04 00:00:00'), ('2022-03-05 00:00:00')),
83+
PARTITION p20220305 VALUES [('2022-03-05 00:00:00'), ('2022-03-06 00:00:00')),
84+
PARTITION p20220306 VALUES [('2022-03-06 00:00:00'), ('2022-03-07 00:00:00')),
85+
PARTITION p20220307 VALUES [('2022-03-07 00:00:00'), ('2022-03-08 00:00:00')),
86+
PARTITION p20220308 VALUES [('2022-03-08 00:00:00'), ('2022-03-09 00:00:00')),
87+
PARTITION p20220309 VALUES [('2022-03-09 00:00:00'), ('2022-03-10 00:00:00')),
88+
PARTITION p20220310 VALUES [('2022-03-10 00:00:00'), ('2022-03-11 00:00:00')),
89+
PARTITION p20220311 VALUES [('2022-03-11 00:00:00'), ('2022-03-12 00:00:00')),
90+
PARTITION p20220312 VALUES [('2022-03-12 00:00:00'), ('2022-03-13 00:00:00')),
91+
PARTITION p20220313 VALUES [('2022-03-13 00:00:00'), ('2022-03-14 00:00:00')),
92+
PARTITION p20220314 VALUES [('2022-03-14 00:00:00'), ('2022-03-15 00:00:00')),
93+
PARTITION p20220315 VALUES [('2022-03-15 00:00:00'), ('2022-03-16 00:00:00')),
94+
PARTITION p20220316 VALUES [('2022-03-16 00:00:00'), ('2022-03-17 00:00:00')),
95+
PARTITION p20220317 VALUES [('2022-03-17 00:00:00'), ('2022-03-18 00:00:00')),
96+
PARTITION p20220318 VALUES [('2022-03-18 00:00:00'), ('2022-03-19 00:00:00')),
97+
PARTITION p20220319 VALUES [('2022-03-19 00:00:00'), ('2022-03-20 00:00:00')),
98+
PARTITION p20220320 VALUES [('2022-03-20 00:00:00'), ('2022-03-21 00:00:00')),
99+
PARTITION p20220321 VALUES [('2022-03-21 00:00:00'), ('2022-03-22 00:00:00')),
100+
PARTITION p20220322 VALUES [('2022-03-22 00:00:00'), ('2022-03-23 00:00:00')),
101+
PARTITION p20220323 VALUES [('2022-03-23 00:00:00'), ('2022-03-24 00:00:00')),
102+
PARTITION p20220324 VALUES [('2022-03-24 00:00:00'), ('2022-03-25 00:00:00')),
103+
PARTITION p20220325 VALUES [('2022-03-25 00:00:00'), ('2022-03-26 00:00:00')),
104+
PARTITION p20220326 VALUES [('2022-03-26 00:00:00'), ('2022-03-27 00:00:00')),
105+
PARTITION p20220327 VALUES [('2022-03-27 00:00:00'), ('2022-03-28 00:00:00')),
106+
PARTITION p20220328 VALUES [('2022-03-28 00:00:00'), ('2022-03-29 00:00:00')),
107+
PARTITION p20220329 VALUES [('2022-03-29 00:00:00'), ('2022-03-30 00:00:00')),
108+
PARTITION p20220330 VALUES [('2022-03-30 00:00:00'), ('2022-03-31 00:00:00')),
109+
PARTITION p20220331 VALUES [('2022-03-31 00:00:00'), ('2022-04-01 00:00:00')),
110+
PARTITION p20220401 VALUES [('2022-04-01 00:00:00'), ('2022-04-02 00:00:00')),
111+
PARTITION p20220402 VALUES [('2022-04-02 00:00:00'), ('2022-04-03 00:00:00')),
112+
PARTITION p20220403 VALUES [('2022-04-03 00:00:00'), ('2022-04-04 00:00:00')),
113+
PARTITION p20220404 VALUES [('2022-04-04 00:00:00'), ('2022-04-05 00:00:00')),
114+
PARTITION p20220405 VALUES [('2022-04-05 00:00:00'), ('2022-04-06 00:00:00')),
115+
PARTITION p20220406 VALUES [('2022-04-06 00:00:00'), ('2022-04-07 00:00:00')),
116+
PARTITION p20220407 VALUES [('2022-04-07 00:00:00'), ('2022-04-08 00:00:00')),
117+
PARTITION p20220408 VALUES [('2022-04-08 00:00:00'), ('2022-04-09 00:00:00')),
118+
PARTITION p20220409 VALUES [('2022-04-09 00:00:00'), ('2022-04-10 00:00:00')),
119+
PARTITION p20220410 VALUES [('2022-04-10 00:00:00'), ('2022-04-11 00:00:00')),
120+
PARTITION p20220411 VALUES [('2022-04-11 00:00:00'), ('2022-04-12 00:00:00')),
121+
PARTITION p20220412 VALUES [('2022-04-12 00:00:00'), ('2022-04-13 00:00:00')),
122+
PARTITION p20220413 VALUES [('2022-04-13 00:00:00'), ('2022-04-14 00:00:00')),
123+
PARTITION p20220414 VALUES [('2022-04-14 00:00:00'), ('2022-04-15 00:00:00')),
124+
PARTITION p20220415 VALUES [('2022-04-15 00:00:00'), ('2022-04-16 00:00:00')),
125+
PARTITION p20220416 VALUES [('2022-04-16 00:00:00'), ('2022-04-17 00:00:00')),
126+
PARTITION p20220417 VALUES [('2022-04-17 00:00:00'), ('2022-04-18 00:00:00')),
127+
PARTITION p20220418 VALUES [('2022-04-18 00:00:00'), ('2022-04-19 00:00:00')),
128+
PARTITION p20220419 VALUES [('2022-04-19 00:00:00'), ('2022-04-20 00:00:00')),
129+
PARTITION p20220420 VALUES [('2022-04-20 00:00:00'), ('2022-04-21 00:00:00')),
130+
PARTITION p20220421 VALUES [('2022-04-21 00:00:00'), ('2022-04-22 00:00:00')),
131+
PARTITION p20220422 VALUES [('2022-04-22 00:00:00'), ('2022-04-23 00:00:00')),
132+
PARTITION p20220423 VALUES [('2022-04-23 00:00:00'), ('2022-04-24 00:00:00')),
133+
PARTITION p20220424 VALUES [('2022-04-24 00:00:00'), ('2022-04-25 00:00:00')),
134+
PARTITION p20220425 VALUES [('2022-04-25 00:00:00'), ('2022-04-26 00:00:00')),
135+
PARTITION p20220426 VALUES [('2022-04-26 00:00:00'), ('2022-04-27 00:00:00')),
136+
PARTITION p20220427 VALUES [('2022-04-27 00:00:00'), ('2022-04-28 00:00:00')),
137+
PARTITION p20220428 VALUES [('2022-04-28 00:00:00'), ('2022-04-29 00:00:00')),
138+
PARTITION p20220429 VALUES [('2022-04-29 00:00:00'), ('2022-04-30 00:00:00')),
139+
PARTITION p20220430 VALUES [('2022-04-30 00:00:00'), ('2022-05-01 00:00:00')),
140+
PARTITION p20220501 VALUES [('2022-05-01 00:00:00'), ('2022-05-02 00:00:00')),
141+
PARTITION p20220502 VALUES [('2022-05-02 00:00:00'), ('2022-05-03 00:00:00')),
142+
PARTITION p20220503 VALUES [('2022-05-03 00:00:00'), ('2022-05-04 00:00:00')),
143+
PARTITION p20220504 VALUES [('2022-05-04 00:00:00'), ('2022-05-05 00:00:00')),
144+
PARTITION p20220505 VALUES [('2022-05-05 00:00:00'), ('2022-05-06 00:00:00')),
145+
PARTITION p20220506 VALUES [('2022-05-06 00:00:00'), ('2022-05-07 00:00:00')),
146+
PARTITION p20220507 VALUES [('2022-05-07 00:00:00'), ('2022-05-08 00:00:00')),
147+
PARTITION p20220508 VALUES [('2022-05-08 00:00:00'), ('2022-05-09 00:00:00')),
148+
PARTITION p20220509 VALUES [('2022-05-09 00:00:00'), ('2022-05-10 00:00:00')),
149+
PARTITION p20220510 VALUES [('2022-05-10 00:00:00'), ('2022-05-11 00:00:00')),
150+
PARTITION p20220511 VALUES [('2022-05-11 00:00:00'), ('2022-05-12 00:00:00')),
151+
PARTITION p20220512 VALUES [('2022-05-12 00:00:00'), ('2022-05-13 00:00:00')),
152+
PARTITION p20220513 VALUES [('2022-05-13 00:00:00'), ('2022-05-14 00:00:00')),
153+
PARTITION p20220514 VALUES [('2022-05-14 00:00:00'), ('2022-05-15 00:00:00')),
154+
PARTITION p20220515 VALUES [('2022-05-15 00:00:00'), ('2022-05-16 00:00:00')),
155+
PARTITION p20220516 VALUES [('2022-05-16 00:00:00'), ('2022-05-17 00:00:00')),
156+
PARTITION p20220517 VALUES [('2022-05-17 00:00:00'), ('2022-05-18 00:00:00')),
157+
PARTITION p20220518 VALUES [('2022-05-18 00:00:00'), ('2022-05-19 00:00:00')),
158+
PARTITION p20220519 VALUES [('2022-05-19 00:00:00'), ('2022-05-20 00:00:00')),
159+
PARTITION p20220520 VALUES [('2022-05-20 00:00:00'), ('2022-05-21 00:00:00')),
160+
PARTITION p20220521 VALUES [('2022-05-21 00:00:00'), ('2022-05-22 00:00:00')),
161+
PARTITION p20220522 VALUES [('2022-05-22 00:00:00'), ('2022-05-23 00:00:00')),
162+
PARTITION p20220523 VALUES [('2022-05-23 00:00:00'), ('2022-05-24 00:00:00')),
163+
PARTITION p20220524 VALUES [('2022-05-24 00:00:00'), ('2022-05-25 00:00:00')),
164+
PARTITION p20220525 VALUES [('2022-05-25 00:00:00'), ('2022-05-26 00:00:00')),
165+
PARTITION p20220526 VALUES [('2022-05-26 00:00:00'), ('2022-05-27 00:00:00')),
166+
PARTITION p20220527 VALUES [('2022-05-27 00:00:00'), ('2022-05-28 00:00:00')),
167+
PARTITION p20220528 VALUES [('2022-05-28 00:00:00'), ('2022-05-29 00:00:00')),
168+
PARTITION p20220529 VALUES [('2022-05-29 00:00:00'), ('2022-05-30 00:00:00')),
169+
PARTITION p20220530 VALUES [('2022-05-30 00:00:00'), ('2022-05-31 00:00:00')),
170+
PARTITION p20220531 VALUES [('2022-05-31 00:00:00'), ('2022-06-01 00:00:00')),
171+
PARTITION p20220601 VALUES [('2022-06-01 00:00:00'), ('2022-06-02 00:00:00')),
172+
PARTITION p20220602 VALUES [('2022-06-02 00:00:00'), ('2022-06-03 00:00:00')),
173+
PARTITION p20220603 VALUES [('2022-06-03 00:00:00'), ('2022-06-04 00:00:00')),
174+
PARTITION p20220604 VALUES [('2022-06-04 00:00:00'), ('2022-06-05 00:00:00')),
175+
PARTITION p20220605 VALUES [('2022-06-05 00:00:00'), ('2022-06-06 00:00:00')),
176+
PARTITION p20220606 VALUES [('2022-06-06 00:00:00'), ('2022-06-07 00:00:00')),
177+
PARTITION p20220607 VALUES [('2022-06-07 00:00:00'), ('2022-06-08 00:00:00')),
178+
PARTITION p20220608 VALUES [('2022-06-08 00:00:00'), ('2022-06-09 00:00:00')),
179+
PARTITION p20220609 VALUES [('2022-06-09 00:00:00'), ('2022-06-10 00:00:00')),
180+
PARTITION p20220610 VALUES [('2022-06-10 00:00:00'), ('2022-06-11 00:00:00')),
181+
PARTITION p20220611 VALUES [('2022-06-11 00:00:00'), ('2022-06-12 00:00:00')),
182+
PARTITION p20220612 VALUES [('2022-06-12 00:00:00'), ('2022-06-13 00:00:00')),
183+
PARTITION p20220613 VALUES [('2022-06-13 00:00:00'), ('2022-06-14 00:00:00')),
184+
PARTITION p20220614 VALUES [('2022-06-14 00:00:00'), ('2022-06-15 00:00:00')),
185+
PARTITION p20220615 VALUES [('2022-06-15 00:00:00'), ('2022-06-16 00:00:00')),
186+
PARTITION p20220616 VALUES [('2022-06-16 00:00:00'), ('2022-06-17 00:00:00')),
187+
PARTITION p20220617 VALUES [('2022-06-17 00:00:00'), ('2022-06-18 00:00:00')),
188+
PARTITION p20220618 VALUES [('2022-06-18 00:00:00'), ('2022-06-19 00:00:00')),
189+
PARTITION p20220619 VALUES [('2022-06-19 00:00:00'), ('2022-06-20 00:00:00')),
190+
PARTITION p20220620 VALUES [('2022-06-20 00:00:00'), ('2022-06-21 00:00:00')),
191+
PARTITION p20220621 VALUES [('2022-06-21 00:00:00'), ('2022-06-22 00:00:00')),
192+
PARTITION p20220622 VALUES [('2022-06-22 00:00:00'), ('2022-06-23 00:00:00')),
193+
PARTITION p20220623 VALUES [('2022-06-23 00:00:00'), ('2022-06-24 00:00:00')),
194+
PARTITION p20220624 VALUES [('2022-06-24 00:00:00'), ('2022-06-25 00:00:00')),
195+
PARTITION p20220625 VALUES [('2022-06-25 00:00:00'), ('2022-06-26 00:00:00')),
196+
PARTITION p20220626 VALUES [('2022-06-26 00:00:00'), ('2022-06-27 00:00:00')),
197+
PARTITION p20220627 VALUES [('2022-06-27 00:00:00'), ('2022-06-28 00:00:00')),
198+
PARTITION p20220628 VALUES [('2022-06-28 00:00:00'), ('2022-06-29 00:00:00')),
199+
PARTITION p20220629 VALUES [('2022-06-29 00:00:00'), ('2022-06-30 00:00:00')),
200+
PARTITION p20220630 VALUES [('2022-06-30 00:00:00'), ('2022-07-01 00:00:00')),
201+
PARTITION p20220701 VALUES [('2022-07-01 00:00:00'), ('2022-07-02 00:00:00')),
202+
PARTITION p20220702 VALUES [('2022-07-02 00:00:00'), ('2022-07-03 00:00:00')),
203+
PARTITION p20220703 VALUES [('2022-07-03 00:00:00'), ('2022-07-04 00:00:00')),
204+
PARTITION p20220704 VALUES [('2022-07-04 00:00:00'), ('2022-07-05 00:00:00')),
205+
PARTITION p20220705 VALUES [('2022-07-05 00:00:00'), ('2022-07-06 00:00:00')),
206+
PARTITION p20220706 VALUES [('2022-07-06 00:00:00'), ('2022-07-07 00:00:00')),
207+
PARTITION p20220707 VALUES [('2022-07-07 00:00:00'), ('2022-07-08 00:00:00')),
208+
PARTITION p20220708 VALUES [('2022-07-08 00:00:00'), ('2022-07-09 00:00:00')),
209+
PARTITION p20220709 VALUES [('2022-07-09 00:00:00'), ('2022-07-10 00:00:00')))
210+
DISTRIBUTED BY HASH(`wfid`) BUCKETS 10
211+
PROPERTIES (
212+
"replication_allocation" = "tag.location.default: 1",
213+
"dynamic_partition.enable" = "true",
214+
"dynamic_partition.time_unit" = "DAY",
215+
"dynamic_partition.time_zone" = "America/New_York",
216+
"dynamic_partition.start" = "-2147483648",
217+
"dynamic_partition.end" = "2",
218+
"dynamic_partition.prefix" = "p",
219+
"dynamic_partition.replication_allocation" = "tag.location.default: 1",
220+
"dynamic_partition.buckets" = "8",
221+
"dynamic_partition.create_history_partition" = "true",
222+
"dynamic_partition.history_partition_num" = "498",
223+
"dynamic_partition.hot_partition_num" = "0",
224+
"dynamic_partition.reserved_history_periods" = "NULL",
225+
"in_memory" = "false",
226+
"storage_format" = "V2"
227+
);

0 commit comments

Comments
 (0)