Slide 128
Slide 128 text
(C) Recruit Technologies Co.,Ltd. All rights reserved.
create table a (id char(10),dy date)
partition by hash(id) subpartition by range(dy)(
partition p1
(
subpartition p1_2016_01_01 values less than (to_date('2016-01-01','YYYY-MM-DD'))
,subpartition p1_2016_01_02 values less than (to_date('2016-01-02','YYYY-MM-DD'))
:
)
,partition p2
(
subpartition p2_2016_01_01 values less than (to_date('2016-01-01','YYYY-MM-DD'))
,subpartition p2_2016_01_02 values less than (to_date('2016-01-02','YYYY-MM-DD'))
:
)
,partition p3
(
subpartition p3_2016_01_01 values less than (to_date('2016-01-01','YYYY-MM-DD'))
,subpartition p3_2016_01_02 values less than (to_date('2016-01-02','YYYY-MM-DD'))
:
)
:
:
,partition p1000
(
subpartition p1000_2016_01_01 values less than (to_date('2016-01-01','YYYY-MM-DD'))
,subpartition p1000_2016_01_02 values less than (to_date('2016-01-02','YYYY-MM-DD'))
:
)
create table a (id char(10),dy date)
partition by hash(id) subpartition by range(dy)
subpartition template
(
subpartition 2016_01_01 values less than (to_date('2016-01-01','YYYY-MM-DD'))
,subpartition 2016_01_02 values less than (to_date('2016-01-02','YYYY-MM-DD'))
:
,subpartition 2016_04_08 values less than (to_date('2016-04-08','YYYY-MM-DD'))
,subpartition 2016_04_09 values less than (to_date('2016-04-09','YYYY-MM-DD'))
)
(
partition p1
,partition p2
:
,partition p1000
);
サブパーティションテンプレート利用で3分で完了
元のクエリイメージ (≒ 100,000行) 修正後のクエリイメージ (≒ 1,100行)
Parse 問題となった例 2
テーブル作成が終わらない part1 part… part1000
p1
s1
.. p1s
100
px
s1
.. pxs
100
p1
00
0s
1
..
p10
000
s10
0
TABLE
PARSE