データセット#
Example1 で使用したテーブルをベースにし、incremental_update が行われるタイミングでレコードを挿入し、どのようにして incremental_update が行われるかを確認しよう。
Example1 で使用したテーブル#
Example1 のデータが、test_id_unification_ex5
データベースに入っていると仮定する。
date |
site_aaa |
site_aaa |
site_xxx |
site_xxx |
site_yyy |
site_yyy |
site_zzz |
site_zzz |
||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
month |
day |
td_client_id |
td_global_id |
td_client_id |
td_global_id |
td_client_id |
td_global_id |
td_client_id |
td_global_id |
|||
1 |
5 |
aaa_001 |
3rd_001 |
yyy_001 |
3rd_001 |
|||||||
15 |
aaa_001 |
3rd_002 |
zzz_001 |
3rd_002 |
||||||||
25 |
aaa_001 |
3rd_003 |
||||||||||
2 |
5 |
aaa_001 |
3rd_004 |
xxx_001 |
3rd_004 |
|||||||
15 |
xxx_001 |
3rd_005 |
yyy_002 |
3rd_005 |
||||||||
25 |
yyy_002 |
3rd_006 |
zzz_003 |
3rd_006 |
||||||||
3 |
5 |
zzz_003 |
3rd_007 |
|||||||||
15 |
xxx_002 |
3rd_008 |
zzz_003 |
3rd_008 |
||||||||
25 |
aaa_002 |
3rd_009 |
xxx_002 |
3rd_009 |
||||||||
4 |
5 |
aaa_002 |
3rd_010 |
yyy_003 |
3rd_010 |
|||||||
15 |
yyy_003 |
3rd_011 |
zzz_004 |
3rd_011 |
||||||||
25 |
xxx_003 |
3rd_012 |
zzz_004 |
3rd_012 |
||||||||
5 |
5 |
aaa_003 |
3rd_013 |
xxx_003 |
3rd_013 |
|||||||
15 |
aaa_003 |
3rd_014 |
||||||||||
25 |
aaa_003 |
3rd_015 |
yyy_004 |
3rd_015 |
zzz_005 |
3rd_015 |
||||||
6 |
5 |
aaa_003 |
3rd_016 |
xxx_004 |
3rd_016 |
|||||||
15 |
xxx_004 |
3rd_017 |
zzz_005 |
3rd_017 |
||||||||
25 |
yyy_005 |
3rd_018 |
zzz_005 |
3rd_018 |
後ほど追記するレコード#
date |
site_aaa |
site_aaa |
site_xxx |
site_xxx |
site_yyy |
site_yyy |
site_zzz |
site_zzz |
||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
month |
day |
td_client_id |
td_global_id |
td_client_id |
td_global_id |
td_client_id |
td_global_id |
td_client_id |
td_global_id |
|||
7 |
5 |
aaa_004 |
3rd_017 |
xxx_005 |
3rd_018 |
yyy_006 |
3rd_019 |
zzz_006 |
3rd_018 |
|||
15 |
aaa_004 |
3rd_018 |
zzz_007 |
3rd_018 |
||||||||
25 |
||||||||||||
8 |
5 |
aaa_005 |
3rd_018 |
xxx_005 |
3rd_018 |
|||||||
15 |
xxx_006 |
3rd_019 |
yyy_006 |
3rd_019 |
zzz_008 |
3rd_019 |
||||||
25 |
aaa_005 |
3rd_019 |
yyy_007 |
3rd_019 |
上記のレコードを途中で追加し、incremental_update を観察することにする。