DDL statements

Use the following DDL statements directly in Athena.

The Athena query engine is based in part on HiveQL DDL.

Athena does not support all DDL statements, and there are some differences between HiveQL DDL and Athena DDL. For more information, see the reference topics in this section and Unsupported DDL.

Topics

• Unsupported DDL
• ALTER DATABASE SET DBPROPERTIES
• ALTER TABLE ADD COLUMNS
• ALTER TABLE ADD PARTITION
• ALTER TABLE DROP PARTITION
• ALTER TABLE RENAME PARTITION
• ALTER TABLE REPLACE COLUMNS
• ALTER TABLE SET LOCATION
• ALTER TABLE SET TBLPROPERTIES
• CREATE DATABASE
• CREATE TABLE
• CREATE TABLE AS
• CREATE VIEW
• DESCRIBE
• DESCRIBE VIEW
• DROP DATABASE
• DROP TABLE
• DROP VIEW
• MSCK REPAIR TABLE
• SHOW COLUMNS
• SHOW CREATE TABLE
• SHOW CREATE VIEW
• SHOW DATABASES
• SHOW PARTITIONS
• SHOW TABLES
• SHOW TBLPROPERTIES
• SHOW VIEWS