1
CREATE TABLESPACE ts1 ADD DATAFILE 'ts1.fts' ENGINE=Falcon;
2
CREATE TABLESPACE ts2 ADD DATAFILE 'ts2.fts' ENGINE=Falcon;
3
CREATE TABLESPACE ts3 ADD DATAFILE 'ts3.fts' ENGINE=Falcon;
4
CREATE TABLE t1 (a INT) ENGINE=Falcon TABLESPACE ts1
5
PARTITION BY RANGE(a) SUBPARTITION BY HASH(a) (
6
PARTITION p1 VALUES LESS THAN (100) TABLESPACE ts2 (
7
SUBPARTITION p1s1 TABLESPACE ts3,
10
PARTITION p2 VALUES LESS THAN MAXVALUE (
15
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
16
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
17
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
18
TEST T1 P1S1 ts3 T1#P#P1#SP#P1S1
19
TEST T1 P1S2 ts2 T1#P#P1#SP#P1S2
20
TEST T1 P2S1 ts1 T1#P#P2#SP#P2S1
21
TEST T1 P2S2 ts1 T1#P#P2#SP#P2S2
24
t1 CREATE TABLE `t1` (
25
`a` int(11) DEFAULT NULL
26
) /*!50100 TABLESPACE `ts1` */ ENGINE=Falcon DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (a) SUBPARTITION BY HASH (a) (PARTITION p1 VALUES LESS THAN (100) (SUBPARTITION p1s1 TABLESPACE = ts3 ENGINE = Falcon, SUBPARTITION p1s2 TABLESPACE = ts2 ENGINE = Falcon), PARTITION p2 VALUES LESS THAN MAXVALUE (SUBPARTITION p2s1 TABLESPACE = ts1 ENGINE = Falcon, SUBPARTITION p2s2 TABLESPACE = ts1 ENGINE = Falcon)) */
27
ALTER TABLE t1 REMOVE PARTITIONING;
28
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
29
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
30
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
32
ALTER TABLE t1 TABLESPACE ts1
33
PARTITION BY RANGE(a) SUBPARTITION BY HASH(a) (
34
PARTITION p1 VALUES LESS THAN (100) TABLESPACE ts2 (
35
SUBPARTITION p1s1 TABLESPACE ts3,
38
PARTITION p2 VALUES LESS THAN (200) (
43
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
44
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
45
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
46
TEST T1 P1S1 ts3 T1#P#P1#SP#P1S1
47
TEST T1 P1S2 ts2 T1#P#P1#SP#P1S2
48
TEST T1 P2S1 ts1 T1#P#P2#SP#P2S1
49
TEST T1 P2S2 ts1 T1#P#P2#SP#P2S2
50
ALTER TABLE t1 ADD PARTITION (PARTITION p3 VALUES LESS THAN MAXVALUE);
51
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
52
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
53
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
54
TEST T1 P1S1 ts3 T1#P#P1#SP#P1S1
55
TEST T1 P1S2 ts2 T1#P#P1#SP#P1S2
56
TEST T1 P2S1 ts1 T1#P#P2#SP#P2S1
57
TEST T1 P2S2 ts1 T1#P#P2#SP#P2S2
58
TEST T1 P3SP0 ts1 T1#P#P3#SP#P3SP0
59
TEST T1 P3SP1 ts1 T1#P#P3#SP#P3SP1
60
ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN
61
MAXVALUE TABLESPACE ts1);
62
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
63
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
64
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
65
TEST T1 P1S1 ts3 T1#P#P1#SP#P1S1
66
TEST T1 P1S2 ts2 T1#P#P1#SP#P1S2
67
TEST T1 P2S1 ts1 T1#P#P2#SP#P2S1
68
TEST T1 P2S2 ts1 T1#P#P2#SP#P2S2
69
TEST T1 P3SP0 ts1 T1#P#P3#SP#P3SP0
70
TEST T1 P3SP1 ts1 T1#P#P3#SP#P3SP1
71
ALTER TABLE t1 REORGANIZE PARTITION p3 INTO (PARTITION p3 VALUES LESS THAN
72
MAXVALUE TABLESPACE ts2);
73
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
74
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
75
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
76
TEST T1 P1S1 ts3 T1#P#P1#SP#P1S1
77
TEST T1 P1S2 ts2 T1#P#P1#SP#P1S2
78
TEST T1 P2S1 ts1 T1#P#P2#SP#P2S1
79
TEST T1 P2S2 ts1 T1#P#P2#SP#P2S2
80
TEST T1 P3SP0 ts2 T1#P#P3#SP#P3SP0
81
TEST T1 P3SP1 ts2 T1#P#P3#SP#P3SP1
82
ALTER TABLE t1 REORGANIZE PARTITION p1 INTO (PARTITION p1 VALUES LESS THAN
83
(100) TABLESPACE ts2);
84
SELECT * FROM INFORMATION_SCHEMA.FALCON_TABLES WHERE
85
TABLE_NAME = 't1' AND SCHEMA_NAME='test';
86
SCHEMA_NAME TABLE_NAME PARTITION TABLESPACE INTERNAL_NAME
87
TEST T1 P2S1 ts1 T1#P#P2#SP#P2S1
88
TEST T1 P2S2 ts1 T1#P#P2#SP#P2S2
89
TEST T1 P3SP0 ts2 T1#P#P3#SP#P3SP0
90
TEST T1 P3SP1 ts2 T1#P#P3#SP#P3SP1
91
TEST T1 P1SP0 ts2 T1#P#P1#SP#P1SP0
92
TEST T1 P1SP1 ts2 T1#P#P1#SP#P1SP1
94
DROP TABLESPACE ts1 ENGINE=Falcon;
95
DROP TABLESPACE ts2 ENGINE=Falcon;
96
DROP TABLESPACE ts3 ENGINE=Falcon;