不支持的 DDL - Amazon Athena

不支持的 DDL

Athena SQL 不支持以下 DDL 语句。有关 Athena 中 Iceberg 表支持的 DDL 语句，请参阅 Iceberg 表架构演进 和 对 Iceberg 表这些其他 DDL 操作。

  • ALTER INDEX

  • ALTER TABLE table_name ARCHIVE PARTITION

  • ALTER TABLE table_name CLUSTERED BY

  • ALTER TABLE table_name DROP COLUMN（支持 Iceberg 表）

  • ALTER TABLE table_name EXCHANGE PARTITION

  • ALTER TABLE table_name NOT CLUSTERED

  • ALTER TABLE table_name NOT SKEWED

  • ALTER TABLE table_name NOT SORTED

  • ALTER TABLE table_name NOT STORED AS DIRECTORIES

  • ALTER TABLE table_name partitionSpec CHANGE COLUMNS

  • ALTER TABLE table_name partitionSpec COMPACT

  • ALTER TABLE table_name partitionSpec CONCATENATE

  • ALTER TABLE table_name partitionSpec SET FILEFORMAT

  • ALTER TABLE table_name RENAME TO（支持 Iceberg 表）

  • ALTER TABLE table_name SET SERDEPROPERTIES

  • ALTER TABLE table_name SET SKEWED LOCATION

  • ALTER TABLE table_name SKEWED BY

  • ALTER TABLE table_name TOUCH

  • ALTER TABLE table_name UNARCHIVE PARTITION

  • COMMIT

  • CREATE INDEX

  • CREATE ROLE

  • CREATE TABLE table_name LIKE existing_table_name

  • CREATE TEMPORARY MACRO

  • DELETE FROM

  • DESCRIBE DATABASE

  • DFS

  • DROP INDEX

  • DROP ROLE

  • DROP TEMPORARY MACRO

  • EXPORT TABLE

  • GRANT ROLE

  • IMPORT TABLE

  • LOCK DATABASE

  • LOCK TABLE

  • REVOKE ROLE

  • ROLLBACK

  • SHOW COMPACTIONS

  • SHOW CURRENT ROLES

  • SHOW GRANT

  • SHOW INDEXES

  • SHOW LOCKS

  • SHOW PRINCIPALS

  • SHOW ROLE GRANT

  • SHOW ROLES

  • SHOW STATS

  • SHOW TRANSACTIONS

  • START TRANSACTION

  • UNLOCK DATABASE

  • UNLOCK TABLE