Amazon S3 Tables の Iceberg テーブルに Amazon Athenaから更新クエリを試す！（今更だったらゴメンね）

[cloudshell-user@ip-10-130-84-16 ~]$ aws s3tables create-table-bucket  --name cm-sample --region us-east-1
{
    "arn": "arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample"
}

[cloudshell-user@ip-10-130-84-16 ~]$ aws s3tables create-namespace --table-bucket-arn arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample --namespace cm_ssb
{
    "tableBucketARN": "arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample",
    "namespace": [
        "cm_ssb"
    ]
}

aws s3tables delete-table --table-bucket-arn arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample --namespace cm_ssb --name lineorder

# s3tablescatalog/cm-sample
# cm_ssb
# lineorder_s3tables
# SELECT * FROM "s3tablescatalog/cm-sample"."cm_ssb"."lineorder_s3tables" limit 10;
[cloudshell-user@ip-10-130-84-16 ~]$ aws s3tables create-table --table-bucket-arn arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample --namespace cm_ssb --name lineorder_s3tables --format ICEBERG --metadata '{
>   "iceberg": {
>     "schema": {
>       "fields": [
>         {"name": "lo_orderkey", "type": "int", "required": true},
>         {"name": "lo_linenumber", "type": "int", "required": true},
>         {"name": "lo_custkey", "type": "int", "required": true},
>         {"name": "lo_partkey", "type": "int", "required": true},
>         {"name": "lo_suppkey", "type": "int", "required": true},
>         {"name": "lo_orderdate", "type": "int", "required": true},
>         {"name": "lo_orderpriority", "type": "string", "required": true},
>         {"name": "lo_shippriority", "type": "string", "required": true},
>         {"name": "lo_quantity", "type": "int", "required": true},
>         {"name": "lo_extendedprice", "type": "int", "required": true},
>         {"name": "lo_ordertotalprice", "type": "int", "required": true},
>         {"name": "lo_discount", "type": "int", "required": true},
>         {"name": "lo_revenue", "type": "int", "required": true},
>         {"name": "lo_supplycost", "type": "int", "required": true},
>         {"name": "lo_tax", "type": "int", "required": true},
>         {"name": "lo_commitdate", "type": "int", "required": true},
>         {"name": "lo_shipmode", "type": "string", "required": true}
>       ]
>     }
>   }
> }'
{
    "tableARN": "arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample/table/e80b8220-55ad-459a-9f5f-a61c3ad11e0b",
    "versionToken": "b72c22cdffe346cd6c3d"
}

[cloudshell-user@ip-10-130-84-16 ~]$ aws s3tables delete-table --table-bucket-arn arn:aws:s3tables:us-east-1:123456789012:bucket/cm-sample --namespace cm_ssb --name lineorder_s3tables