DDL incompatível - Amazon Athena

DDL incompatível

As instruções DDL a seguir não são aceitas no Athena. Para obter as instruções DDL compatíveis com as tabelas do Iceberg no Athena, consulte Evoluir o esquema de tabelas do Iceberg e Executar outras operações de DDL em tabelas do Iceberg.

  • ALTER INDEX

  • ALTER TABLE table_name ARCHIVE PARTITION

  • ALTER TABLE table_name CLUSTERED BY

  • ALTER TABLE table_name DROP COLUMN (compatível com as tabelas do 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 (compatível com as tabelas do 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

  • CRIAR PERFIL

  • 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

  • MOSTRAR ESTATÍSTICAS

  • SHOW TRANSACTIONS

  • START TRANSACTION

  • UNLOCK DATABASE

  • UNLOCK TABLE