本文為英文版的機器翻譯版本，如內容有任何歧義或不一致之處，概以英文版為準。

# 遷移選項摘要
<a name="migration-options"></a>

此資料表摘要說明每個遷移選項的主要特性和考量事項。


| **功能** | **就地遷移** [快照](table-migration-inplace.md#in-place-snapshot) | **就地遷移** [migrate](table-migration-inplace.md#in-place-migrate) | **完整資料遷移** [CTAS 或 (CREATE TABLE \$1 INSERT)](table-migration-full.md) | 
| --- | --- | --- | --- | 
| **資料配置改善是遷移程序的一部分** |  |  |  | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是 | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是 | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是 | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是 | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是 | 
| **支援的檔案格式** | Parquet、Avro、ORC | Parquet、Avro、ORC | Parquet、Avro、ORC、JSON、CSV | 
| **Iceberg 資料表取代來源資料表** |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否（建立新的資料表， 但您可以使用其他步驟取代來源資料表） | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是（建立備份資料表並以 Iceberg 資料表取代來源資料表） |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否（建立新的資料表） | 
| **來源資料表影響** |  |  |  | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) | 損毀來源資料表 | Corrupts 備份資料表 | 安全、來源不受影響 | 
| **Iceberg 資料表影響** |  |  |  | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) | Corrupts Iceberg 資料表 | Corrupts Iceberg 資料表 | 不會影響 Iceberg 資料表 | 
| [\[See the AWS documentation website for more details\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/migration-options.html) | 新資料表上看不到（需要將分割區與 合併`add_files`) | 新資料表上看不到（需要將分割區與 合併`add_files`) | 新資料表上看不到（需要`INSERT INTO`新資料表） | 
| **成本** | 低 | 低 | 較高 （完整資料重寫） | 
| **遷移速度** | 快速 | 快速 | 較慢 | 
| **可用於遷移至 Amazon S3 資料表** |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否 | ![\[Yes\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-yes.png) 是 | 
| **需要手動 DDL** |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否（從來源資料表複製結構描述和分割區） |  ![\[No\]](http://docs.aws.amazon.com/zh_tw/prescriptive-guidance/latest/apache-iceberg-on-aws/images/icon-no.png) 否（從來源資料表複製結構描述和分割區） | 如果使用 CTAS， 只需要指定分割 | 
| **最佳使用** | 無需重寫資料的快速遷移，允許side-by-side使用 Hive 和 Iceberg 進行測試或逐步轉換。 | 可接受立即切換時，在不重寫資料的情況下更換 Hive 資料表。 | 完整 Iceberg 最佳化與資料重寫。重新設計分割區或結構描述，或改善配置和效能時的理想選擇。如果可能，一律建議。 |