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 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 July 25, 2018.
<< Overview of Impala Views | ©2016 Cloudera, Inc. All rights reserved | DDL Statements >> |
Terms and Conditions Privacy Policy |