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