Cloudera Docs

Hive statement types

Lists the SQL statement types for workloads that use Apache Hive. You can find the statement types on the Hive Queries page in the Type list.

Table 1. Hive Statement Types
Statement Type Description
DDL The Data Definition Language, whose SQL statements change the structure of the database by creating, deleting, or modifying schema objects, such as databases, tables, and views.

For example, CREATE TABLE;
DML The Data Manipulation Language, whose SQL statements modify the data stored in tables.

For example, INSERT;
EXPLAIN Generates a query execution plan for a specific query.

For example, EXPLAIN SELECT * FROM table_1;
LOAD Loads data from an external data source into a table.

For example, LOAD DATA INPATH 'hdfs_file_or_directory_path' INTO TABLE tablename;
QUERY Requests data from a data source.

For example, Select * FROM table_1;