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.
The following sections show the major SQL statements that you work with in Impala:
- DDL Statements
- DML Statements
- ALTER TABLE Statement
- ALTER VIEW
- COMPUTE STATS
- CREATE DATABASE
- CREATE FUNCTION
- CREATE ROLE
- CREATE TABLE
- CREATE VIEW
- DESCRIBE
- DROP DATABASE
- DROP FUNCTION
- DROP ROLE
- DROP STATS
- DROP TABLE
- DROP VIEW
- EXPLAIN
- GRANT
- INSERT
- INVALIDATE METADATA
- LOAD DATA
- REFRESH
- REVOKE
- SELECT
- SET
- Query Options for the SET Statement
- ABORT_ON_DEFAULT_LIMIT_EXCEEDED
- ABORT_ON_ERROR
- ALLOW_UNSUPPORTED_FORMATS
- APPX_COUNT_DISTINCT
- BATCH_SIZE
- COMPRESSION_CODEC
- DEBUG_ACTION
- DEFAULT_ORDER_BY_LIMIT
- DISABLE_CODEGEN
- DISABLE_UNSAFE_SPILLS
- EXEC_SINGLE_NODE_ROWS_THRESHOLD
- EXPLAIN_LEVEL
- HBASE_CACHE_BLOCKS
- HBASE_CACHING
- MAX_ERRORS
- MAX_IO_BUFFERS
- MAX_SCAN_RANGE_LENGTH
- MEM_LIMIT
- NUM_NODES
- NUM_SCANNER_THREADS
- PARQUET_COMPRESSION_CODEC
- PARQUET_FILE_SIZE
- QUERY_TIMEOUT_S
- REQUEST_POOL
- RESERVATION_REQUEST_TIMEOUT
- SUPPORT_START_OVER
- SYNC_DDL
- V_CPU_CORES
- Query Options for the SET Statement
- SHOW
- USE