Skip to content

Commit 2a8d3f8

Browse files
JNSimbazy-kkk
andauthored
add BSZG & KEEP user case (apache#147)
# Checklist * 内部Jira: http://jira.selectdb.com:8090/browse/CIR-1957 * 修复PR:apache#18292 * master: * 1.2-lts: * 1.2-lts: * Doris-master: * [x] 已修复 * [ ] 未修复 * [ ] 无问题 * Doris-1.2-lts: * [ ] 已修复 * [x] 未修复 * [ ] 无问题 * Doris-1.1-lts: * [ ] 已修复 * [ ] 未修复 * [x] 无问题 * 内部Jira: http://jira.selectdb.com:8090/browse/CIR-1843 * 修复PR:apache#17944 * master: * 1.2-lts: * 1.2-lts: * Doris-master: * [x] 已修复 * [ ] 未修复 * [ ] 无问题 * Doris-1.2-lts: * [x] 已修复 * [] 未修复 * [ ] 无问题 * Doris-1.1-lts: * [ ] 已修复 * [ ] 未修复 * [x] 无问题 --------- Co-authored-by: wudi <> Co-authored-by: zy-kk <[email protected]>
1 parent ca52895 commit 2a8d3f8

21 files changed

Lines changed: 3194 additions & 0 deletions
Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,3 @@
1+
-- This file is automatically generated. You should know what you did if you want to edit this
2+
-- !q1 --
3+

‎regression-test/data/usercases/KEEP/dwd_keep_content_homepage_entry_rec_ds.csv‎

Lines changed: 1000 additions & 0 deletions
Large diffs are not rendered by default.

‎regression-test/data/usercases/KEEP/dwd_keep_not_clock_entry.csv‎

Lines changed: 1000 additions & 0 deletions
Large diffs are not rendered by default.
Lines changed: 162 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,162 @@
1+
-- This file is automatically generated. You should know what you did if you want to edit this
2+
-- !q1 --
3+
$& 445 151 310 20 36 0 118 22 48 0.3393258426966292 70 0.08089887640449438 0.0 0.2651685393258427
4+
2019-05-04 3 0 3 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
5+
2019-05-05 3 0 3 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
6+
2019-05-10 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
7+
2019-05-22 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
8+
2019-05-25 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
9+
2019-05-26 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
10+
2019-05-27 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
11+
2019-05-29 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
12+
2019-05-31 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
13+
2019-06-02 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
14+
2019-06-22 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
15+
2019-06-24 2 0 2 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
16+
2019-06-25 3 0 3 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
17+
2019-06-26 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
18+
2019-07-07 2 2 2 \N 2 0 0 0 0 1.0 0 1.0 0.0 0.0
19+
2019-07-09 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
20+
2019-07-28 2 0 2 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
21+
2019-07-29 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
22+
2019-07-30 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
23+
2019-07-31 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
24+
2019-08-02 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
25+
2019-08-03 2 0 2 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
26+
2019-08-17 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
27+
2019-08-20 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
28+
2019-08-21 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
29+
2019-08-23 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
30+
2019-08-26 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
31+
2019-09-06 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
32+
2019-09-08 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
33+
2019-09-09 3 1 3 \N 0 0 1 0 0 0.3333333333333333 0 0.0 0.0 0.3333333333333333
34+
2019-09-10 2 2 2 \N 2 0 0 0 0 1.0 0 1.0 0.0 0.0
35+
2019-09-19 3 1 3 \N 1 0 0 0 1 0.3333333333333333 1 0.3333333333333333 0.0 0.0
36+
2019-09-20 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
37+
2019-09-23 2 0 2 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
38+
2019-09-27 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
39+
2019-10-27 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
40+
2019-10-28 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
41+
2019-10-29 2 1 2 \N 0 0 1 0 0 0.5 0 0.0 0.0 0.5
42+
2019-10-30 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
43+
2019-10-31 3 0 3 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
44+
2019-11-02 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
45+
2019-11-04 2 1 2 \N 1 0 0 0 0 0.5 0 0.5 0.0 0.0
46+
2019-11-11 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
47+
2019-11-19 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
48+
2019-11-22 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
49+
2019-12-04 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
50+
2019-12-07 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
51+
2019-12-08 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
52+
2019-12-12 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
53+
2019-12-13 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
54+
2019-12-16 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
55+
2019-12-30 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
56+
2019-12-31 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
57+
2020-01-01 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
58+
2020-01-03 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
59+
2020-02-24 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
60+
2020-03-04 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
61+
2020-03-13 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
62+
2020-03-18 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
63+
2020-03-19 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
64+
2020-04-09 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
65+
2020-04-12 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
66+
2020-04-17 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
67+
2020-04-25 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
68+
2020-04-29 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
69+
2020-05-04 1 1 1 \N 0 0 1 0 1 1.0 1 0.0 0.0 1.0
70+
2020-05-10 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
71+
2020-05-13 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
72+
2020-05-31 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
73+
2020-06-01 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
74+
2020-06-03 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
75+
2020-06-10 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
76+
2020-06-12 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
77+
2020-06-14 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
78+
2020-06-15 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
79+
2020-06-19 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
80+
2020-06-24 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
81+
2020-06-27 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
82+
2020-07-04 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
83+
2020-07-05 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
84+
2020-07-06 1 0 1 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
85+
2020-07-23 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
86+
2020-07-25 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
87+
2020-08-04 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
88+
2020-08-19 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
89+
2020-08-28 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
90+
2020-09-13 1 1 1 \N 1 0 1 0 1 1.0 1 1.0 0.0 1.0
91+
2020-09-16 1 1 1 \N 1 0 0 1 0 1.0 1 1.0 0.0 0.0
92+
2020-09-17 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
93+
2020-09-18 1 1 1 \N 0 0 1 0 0 1.0 0 0.0 0.0 1.0
94+
2020-09-29 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
95+
2020-10-07 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
96+
2020-10-13 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
97+
2020-10-19 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
98+
2020-11-03 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
99+
2020-11-07 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
100+
2020-11-23 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
101+
2020-11-29 1 1 1 \N 1 0 0 0 0 1.0 0 1.0 0.0 0.0
102+
2020-12-04 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
103+
2020-12-06 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
104+
2020-12-25 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
105+
2020-12-27 1 0 1 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
106+
2021-01-01 6 3 6 \N 0 0 3 0 0 0.5 0 0.0 0.0 0.5
107+
2021-01-02 2 0 2 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
108+
2021-01-03 4 3 4 \N 1 0 2 0 1 0.75 1 0.25 0.0 0.5
109+
2021-01-04 5 4 5 \N 1 0 3 1 1 0.8 2 0.2 0.0 0.6
110+
2021-01-05 7 4 7 \N 1 0 3 2 0 0.5714285714285714 2 0.14285714285714285 0.0 0.42857142857142855
111+
2021-01-06 6 3 6 \N 0 0 3 0 0 0.5 0 0.0 0.0 0.5
112+
2021-01-07 6 4 6 \N 0 0 4 1 1 0.6666666666666666 2 0.0 0.0 0.6666666666666666
113+
2021-01-08 4 0 4 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
114+
2021-01-09 4 2 4 \N 0 0 2 0 0 0.5 0 0.0 0.0 0.5
115+
2021-01-10 2 1 2 \N 1 0 0 0 0 0.5 0 0.5 0.0 0.0
116+
2021-01-11 4 2 4 \N 0 0 2 0 0 0.5 0 0.0 0.0 0.5
117+
2021-01-12 6 3 6 \N 0 0 3 0 0 0.5 0 0.0 0.0 0.5
118+
2021-01-13 6 2 6 \N 0 0 2 2 1 0.3333333333333333 3 0.0 0.0 0.3333333333333333
119+
2021-01-14 5 1 5 \N 0 0 1 2 0 0.2 2 0.0 0.0 0.2
120+
2021-01-15 4 3 4 \N 0 0 3 0 2 0.75 2 0.0 0.0 0.75
121+
2021-01-16 4 2 4 \N 1 0 1 0 1 0.5 1 0.25 0.0 0.25
122+
2021-01-17 3 0 3 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
123+
2021-01-18 5 4 5 \N 0 0 4 1 0 0.8 1 0.0 0.0 0.8
124+
2021-01-19 6 2 6 \N 1 0 1 0 3 0.3333333333333333 3 0.16666666666666666 0.0 0.16666666666666666
125+
2021-01-20 4 1 4 \N 0 0 1 0 0 0.25 0 0.0 0.0 0.25
126+
2021-01-21 2 0 2 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
127+
2021-01-22 12 4 12 \N 0 0 4 0 2 0.3333333333333333 2 0.0 0.0 0.3333333333333333
128+
2021-01-23 4 2 4 \N 0 0 2 0 0 0.5 0 0.0 0.0 0.5
129+
2021-01-24 5 1 5 \N 0 0 1 0 2 0.2 2 0.0 0.0 0.2
130+
2021-01-25 5 3 5 \N 0 0 3 1 1 0.6 2 0.0 0.0 0.6
131+
2021-01-26 6 3 6 \N 1 0 3 1 1 0.5 2 0.16666666666666666 0.0 0.5
132+
2021-01-27 8 2 8 \N 0 0 2 0 0 0.25 0 0.0 0.0 0.25
133+
2021-01-28 9 2 9 \N 0 0 2 1 0 0.2222222222222222 1 0.0 0.0 0.2222222222222222
134+
2021-01-29 5 2 5 \N 0 0 2 0 1 0.4 1 0.0 0.0 0.4
135+
2021-01-30 7 3 7 \N 1 0 2 0 1 0.42857142857142855 1 0.14285714285714285 0.0 0.2857142857142857
136+
2021-01-31 2 1 2 \N 0 0 1 0 1 0.5 1 0.0 0.0 0.5
137+
2021-02-01 11 4 11 \N 2 0 2 0 1 0.36363636363636365 1 0.18181818181818182 0.0 0.18181818181818182
138+
2021-02-02 9 4 9 \N 1 0 3 0 0 0.4444444444444444 0 0.1111111111111111 0.0 0.3333333333333333
139+
2021-02-03 10 3 9 \N 0 0 3 2 1 0.3 3 0.0 0.0 0.3
140+
2021-02-04 5 1 5 \N 0 0 1 0 0 0.2 0 0.0 0.0 0.2
141+
2021-02-05 6 2 6 \N 0 0 2 0 0 0.3333333333333333 0 0.0 0.0 0.3333333333333333
142+
2021-02-06 7 5 6 \N 1 0 4 1 1 0.7142857142857143 2 0.14285714285714285 0.0 0.5714285714285714
143+
2021-02-07 3 0 3 \N 0 0 0 0 1 0.0 1 0.0 0.0 0.0
144+
2021-02-08 10 3 10 \N 0 0 3 0 0 0.3 0 0.0 0.0 0.3
145+
2021-02-09 7 2 7 \N 0 0 2 0 0 0.2857142857142857 0 0.0 0.0 0.2857142857142857
146+
2021-02-10 7 4 7 \N 1 0 4 1 1 0.5714285714285714 2 0.14285714285714285 0.0 0.5714285714285714
147+
2021-02-11 7 3 7 \N 0 0 3 0 0 0.42857142857142855 0 0.0 0.0 0.42857142857142855
148+
2021-02-12 5 1 5 \N 0 0 1 0 0 0.2 0 0.0 0.0 0.2
149+
2021-02-13 5 3 5 \N 1 0 2 0 0 0.6 0 0.2 0.0 0.4
150+
2021-02-14 6 1 6 \N 0 0 1 0 0 0.16666666666666666 0 0.0 0.0 0.16666666666666666
151+
2021-02-15 2 2 2 \N 0 0 2 0 0 1.0 0 0.0 0.0 1.0
152+
2021-02-16 4 1 4 \N 1 0 0 0 0 0.25 0 0.25 0.0 0.0
153+
2021-02-17 4 2 4 \N 0 0 2 0 1 0.5 1 0.0 0.0 0.5
154+
2021-02-18 7 3 7 \N 1 0 2 0 0 0.42857142857142855 0 0.14285714285714285 0.0 0.2857142857142857
155+
2021-02-19 7 2 7 \N 0 0 2 2 1 0.2857142857142857 3 0.0 0.0 0.2857142857142857
156+
2021-02-20 6 1 6 \N 1 0 0 0 0 0.16666666666666666 0 0.16666666666666666 0.0 0.0
157+
2021-02-21 6 2 6 \N 1 0 1 0 0 0.3333333333333333 0 0.16666666666666666 0.0 0.16666666666666666
158+
2021-02-22 8 4 8 \N 0 0 4 1 1 0.5 2 0.0 0.0 0.5
159+
2021-02-23 6 2 6 \N 1 0 1 1 0 0.3333333333333333 1 0.16666666666666666 0.0 0.16666666666666666
160+
2021-02-24 5 2 5 \N 0 0 2 1 1 0.4 2 0.0 0.0 0.4
161+
2021-02-25 3 0 3 \N 0 0 0 0 0 0.0 0 0.0 0.0 0.0
162+
Lines changed: 31 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,31 @@
1+
CREATE TABLE `all_dim_financial_cube_date_load_market` (
2+
`brand` varchar(200) NULL COMMENT '',
3+
`ops_market` varchar(200) NULL COMMENT '',
4+
`calendar_date` varchar(200) NULL COMMENT '',
5+
`week_day_type` varchar(200) NULL COMMENT '',
6+
`summary` varchar(1000) NULL COMMENT '',
7+
`add_info` varchar(1000) NULL COMMENT '',
8+
`weekday_type_delivery` varchar(200) NULL COMMENT '',
9+
`promotion_info` varchar(1000) NULL COMMENT '',
10+
`promotion_dine_in` varchar(200) NULL COMMENT '',
11+
`promotion_delivery` varchar(200) NULL COMMENT '',
12+
`modifiedTime` varchar(200) NULL COMMENT '',
13+
`inserttime` varchar(200) NULL COMMENT '',
14+
`reserve1` varchar(200) NULL COMMENT '',
15+
`reserve2` varchar(200) NULL COMMENT '',
16+
`reserve3` varchar(200) NULL COMMENT '',
17+
`reserve4` varchar(200) NULL COMMENT '',
18+
`reserve5` varchar(200) NULL COMMENT '',
19+
`reserve6` varchar(200) NULL COMMENT '',
20+
`reserve7` varchar(200) NULL COMMENT '',
21+
`reserve8` varchar(200) NULL COMMENT '',
22+
`reserve9` varchar(200) NULL COMMENT '',
23+
`reserve10` varchar(200) NULL COMMENT '',
24+
`last_update_date` varchar(200) NULL COMMENT ''
25+
) ENGINE=OLAP
26+
DUPLICATE KEY(`brand`, `ops_market`, `calendar_date`)
27+
COMMENT ''
28+
DISTRIBUTED BY HASH(`brand`, `ops_market`) BUCKETS 3
29+
PROPERTIES (
30+
"replication_allocation" = "tag.location.default: 1"
31+
);
Lines changed: 34 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,34 @@
1+
CREATE TABLE `all_dim_financial_cube_date_load_rsc` (
2+
`calendar_date` varchar(200) NULL COMMENT '',
3+
`week_detail` varchar(200) NULL COMMENT '',
4+
`week` varchar(200) NULL COMMENT '',
5+
`week_day_name` varchar(200) NULL COMMENT '',
6+
`week_analysis` varchar(200) NULL COMMENT '',
7+
`year` varchar(200) NULL COMMENT '',
8+
`month` varchar(200) NULL COMMENT '',
9+
`period` varchar(200) NULL COMMENT '',
10+
`day_type1` varchar(200) NULL COMMENT '',
11+
`day_type2` varchar(200) NULL COMMENT '',
12+
`ly_calendar_date` varchar(200) NULL COMMENT '',
13+
`ly_week_day_name` varchar(200) NULL COMMENT '',
14+
`lly_calendar_date` varchar(200) NULL COMMENT '',
15+
`lly_week_day_name` varchar(200) NULL COMMENT '',
16+
`holiday_ph1` varchar(200) NULL,
17+
`holiday_ph2` varchar(200) NULL,
18+
`holiday_kfc1` varchar(200) NULL,
19+
`holiday_kfc2` varchar(200) NULL,
20+
`modifiedTime` varchar(200) NULL,
21+
`inserttime` varchar(200) NULL,
22+
`last_update_date` varchar(200) NULL COMMENT '',
23+
`reserve1` varchar(200) NULL COMMENT '',
24+
`reserve2` varchar(200) NULL COMMENT '',
25+
`reserve3` varchar(200) NULL COMMENT '',
26+
`reserve4` varchar(200) NULL COMMENT '',
27+
`reserve5` varchar(200) NULL COMMENT ''
28+
) ENGINE=OLAP
29+
DUPLICATE KEY(`calendar_date`)
30+
COMMENT ''
31+
DISTRIBUTED BY HASH(`year`) BUCKETS 3
32+
PROPERTIES (
33+
"replication_allocation" = "tag.location.default: 1"
34+
);
Lines changed: 14 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,14 @@
1+
CREATE TABLE `all_dim_financial_cube_mixlabel_load_result` (
2+
`brand` varchar(50) NULL,
3+
`StoreCode` varchar(100) NULL,
4+
`ops_market` varchar(100) NULL,
5+
`effect_date` varchar(100) NULL,
6+
`events_list` array<varchar(10)> NULL,
7+
`create_time` datetime NULL
8+
) ENGINE=OLAP
9+
DUPLICATE KEY(`brand`, `StoreCode`)
10+
COMMENT ''
11+
DISTRIBUTED BY HASH(`brand`, `StoreCode`) BUCKETS 3
12+
PROPERTIES (
13+
"replication_allocation" = "tag.location.default: 1"
14+
);

0 commit comments

Comments
 (0)