Data Definition

Commonly used HiveQL DDL statements are listed below:

CREATE DATABASE/SCHEMA, TABLE, VIEW, FUNCTION, INDEX
DROP DATABASE/SCHEMA, TABLE, VIEW, INDEX
TRUNCATE TABLE
ALTER DATABASE/SCHEMA, TABLE, VIEW
MSCK REPAIR TABLE (or ALTER TABLE RECOVER PARTITIONS)
SHOW DATABASES, TABLES, TBLPROPERTIES, VIEWS, PARTITIONS, FUNCTIONS, INDEXES, COLUMNS, CREATE TABLE
DESCRIBE DATABASE/SCHEMA, table_name, view_name

PARTITION statements are usually options of TABLE statements, except for SHOW PARTITIONS. For more details, please refer

Last updated 5 years ago