Athena SQL no admite las siguientes instrucciones DDL. Para ver las instrucciones de DDL compatibles con las tablas de Iceberg en Athena, consulte Evolución del esquema de tabla de Iceberg y Otras operaciones de DDL en tablas de Iceberg.
-
ALTER INDEX
-
ALTER TABLE
table_name
ARCHIVE PARTITION -
ALTER TABLE
table_name
CLUSTERED BY -
ALTER TABLE
table_name
DROP COLUMN (compatible con tablas de 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 (compatible con las tablas de 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
-
CREAR ROL
-
CREATE TABLE
table_name
LIKEexisting_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 ESTADÍSTICAS
-
SHOW TRANSACTIONS
-
START TRANSACTION
-
UNLOCK DATABASE
-
UNLOCK TABLE