지원되지 않는 DDL - Amazon Athena

지원되지 않는 DDL

다음 DDL 문은 Athena SQL에서 지원되지 않습니다. 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 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