Cloudera Enterprise 5.16.x | Other versions

Impala 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.

Note:

In 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 DATABASE Statement
ALTER TABLE Statement
ALTER VIEW Statement
COMPUTE STATS Statement
CREATE DATABASE Statement
CREATE FUNCTION Statement
CREATE ROLE Statement (CDH 5.2 or higher only)
CREATE TABLE Statement
CREATE VIEW Statement
DELETE Statement (CDH 5.10 or higher only)
DESCRIBE Statement
DROP DATABASE Statement
DROP FUNCTION Statement
DROP ROLE Statement (CDH 5.2 or higher only)
DROP STATS Statement
DROP TABLE Statement
DROP VIEW Statement
EXPLAIN Statement
GRANT Statement (CDH 5.2 or higher only)
INSERT Statement
INVALIDATE METADATA Statement
LOAD DATA Statement
REFRESH Statement
REFRESH FUNCTIONS Statement
REVOKE Statement (CDH 5.2 or higher only)
SELECT Statement
SET Statement
SHOW Statement
TRUNCATE TABLE Statement (CDH 5.5 or higher only)
UPDATE Statement (CDH 5.10 or higher only)
UPSERT Statement (CDH 5.10 or higher only)
USE Statement
Optimizer Hints in Impala

Page generated October 24, 2018.