1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
CREATE TABLE `trips` (
`id` bigint(20) UNSIGNED NOT NULL COMMENT 'Unique trip Id',
`trip_code` int(11) UNSIGNED NOT NULL COMMENT 'Trip code',
`trip_category` int(11) UNSIGNED NOT NULL COMMENT 'Trip category',
`trip_date` date NOT NULL COMMENT 'The trip date'
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = 'The trips' PARTITION BY LIST(trip_category) SUBPARTITION BY HASH(DAY(trip_date)) SUBPARTITIONS 31 (
PARTITION p1
VALUES
IN(1),
PARTITION p2
VALUES
IN(2),
PARTITION p3
VALUES
IN(3),
PARTITION p4
VALUES
IN(4),
PARTITION p5
VALUES
IN(5),
PARTITION p6
VALUES
IN(6),
PARTITION p7
VALUES
IN(7),
PARTITION p8
VALUES
IN(8),
PARTITION p9
VALUES
IN(9),
PARTITION p10
VALUES
IN(10),
PARTITION p11
VALUES
IN(11),
PARTITION p12
VALUES
IN(12),
PARTITION p13
VALUES
IN(13),
PARTITION p14
VALUES
IN(14),
PARTITION p15
VALUES
IN(15),
PARTITION p16
VALUES
IN(16),
PARTITION p17
VALUES
IN(17),
PARTITION p18
VALUES
IN(18),
PARTITION p19
VALUES
IN(19),
PARTITION p20
VALUES
IN(20),
PARTITION p21
VALUES
IN(21),
PARTITION p22
VALUES
IN(22),
PARTITION p23
VALUES
IN(23),
PARTITION p24
VALUES
IN(24),
PARTITION p25
VALUES
IN(25),
PARTITION p26
VALUES
IN(26),
PARTITION p27
VALUES
IN(27),
PARTITION p28
VALUES
IN(28),
PARTITION p29
VALUES
IN(29),
PARTITION p30
VALUES
IN(30),
PARTITION p31
VALUES
IN(31)
);
|
