没有特殊情况尽量用bulk，bulk方式相比row yb row方式会快很多。
Table 'testtable' in location 'test' (199241477 rows) and location 'test1' (198948686 rows) differed by 292791 inserts (compression=99.8%). This row-wise refresh took 36.99 minutes.
bulk方式:
Refreshed 'testtable' from location 'test' to location 'test2' (199241477 rows 228 wide compression=98.8%). This bulk refresh took 15.76 minutes.
以下是刷新同一张大表的时间对比：
row by row方式:Table 'testtable' in location 'test' (199241477 rows) and location 'test1' (198948686 rows) differed by 292791 inserts (compression=99.8%). This row-wise refresh took 36.99 minutes.
bulk方式:
Refreshed 'testtable' from location 'test' to location 'test2' (199241477 rows 228 wide compression=98.8%). This bulk refresh took 15.76 minutes.
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
