This is the documentation for CDH 5.0.x. Documentation for other versions is available at Cloudera Documentation.
SQL Statements
The Impala SQL dialect supports a range of standard elements, plus some extensions for Big Data use cases related to data loading and data warehousing.
NoteIn the impala-shell interpreter, a semicolon at the end of each statement is required. Since the semicolon is not actually part of the SQL syntax, we do not include it in the syntax definition of each statement, but we do show it in examples intended to be run in impala-shell.
The following sections show the major SQL statements that you work with in Impala:
- DDL Statements
- DML Statements
- ALTER TABLE Statement
- ALTER VIEW Statement
- COMPUTE STATS Statement
- CREATE DATABASE Statement
- CREATE FUNCTION Statement
- CREATE TABLE Statement
- CREATE VIEW Statement
- DESCRIBE Statement
- DROP DATABASE Statement
- DROP FUNCTION Statement
- DROP TABLE Statement
- DROP VIEW Statement
- EXPLAIN Statement
- INSERT Statement
- INVALIDATE METADATA Statement
- LOAD DATA Statement
- REFRESH Statement
- SELECT Statement
- SHOW Statement
- USE Statement
| << Schema Objects and Object Names | DDL Statements >> | |