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
- ALTER VIEW
- COMPUTE STATS
- CREATE DATABASE
- CREATE FUNCTION
- CREATE ROLE
- CREATE TABLE
- CREATE VIEW
- DELETE
- DESCRIBE
- DROP DATABASE
- DROP FUNCTION
- DROP ROLE
- DROP STATS
- DROP TABLE
- DROP VIEW
- EXPLAIN
- GRANT
- INSERT
- INVALIDATE METADATA
- LOAD DATA
- REFRESH
- REFRESH FUNCTIONS
- 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
- BUFFER_POOL_LIMIT
- COMPRESSION_CODEC
- COMPUTE_STATS_MIN_SAMPLE_SIZE
- DEBUG_ACTION
- DECIMAL_V2
- DEFAULT_JOIN_DISTRIBUTION_MODE
- DEFAULT_ORDER_BY_LIMIT
- DEFAULT_SPILLABLE_BUFFER_SIZE
- DISABLE_CODEGEN
- DISABLE_CODEGEN_ROWS_THRESHOLD
- DISABLE_ROW_RUNTIME_FILTERING
- DISABLE_STREAMING_PREAGGREGATIONS
- DISABLE_UNSAFE_SPILLS
- ENABLE_EXPR_REWRITES
- EXEC_SINGLE_NODE_ROWS_THRESHOLD
- EXEC_TIME_LIMIT_S
- EXPLAIN_LEVEL
- HBASE_CACHE_BLOCKS
- HBASE_CACHING
- IDLE_SESSION_TIMEOUT
- LIVE_PROGRESS
- LIVE_SUMMARY
- MAX_ERRORS
- MAX_IO_BUFFERS
- MAX_NUM_RUNTIME_FILTERS
- MAX_ROW_SIZE
- MAX_SCAN_RANGE_LENGTH
- MEM_LIMIT
- MIN_SPILLABLE_BUFFER_SIZE
- MT_DOP
- NUM_NODES
- NUM_SCANNER_THREADS
- OPTIMIZE_PARTITION_KEY_SCANS
- PARQUET_COMPRESSION_CODEC
- PARQUET_ANNOTATE_STRINGS_UTF8
- PARQUET_ARRAY_RESOLUTION
- PARQUET_DICTIONARY_FILTERING
- PARQUET_FALLBACK_SCHEMA_RESOLUTION
- PARQUET_FILE_SIZE
- PARQUET_READ_STATISTICS
- PREFETCH_MODE
- QUERY_TIMEOUT_S
- REQUEST_POOL
- REPLICA_PREFERENCE
- RUNTIME_BLOOM_FILTER_SIZE
- RUNTIME_FILTER_MAX_SIZE
- RUNTIME_FILTER_MIN_SIZE
- RUNTIME_FILTER_MODE
- RUNTIME_FILTER_WAIT_TIME_MS
- S3_SKIP_INSERT_STAGING
- SCAN_NODE_CODEGEN_THRESHOLD
- SCHEDULE_RANDOM_REPLICA
- SCRATCH_LIMIT
- SUPPORT_START_OVER
- SYNC_DDL
- Query Options for the SET Statement
- SHOW
- SHOW FILES Statement
- SHOW ROLES Statement
- SHOW CURRENT ROLES
- SHOW ROLE GRANT GROUP Statement
- SHOW GRANT ROLE Statement
- SHOW DATABASES
- SHOW TABLES Statement
- SHOW CREATE TABLE Statement
- SHOW CREATE VIEW Statement
- SHOW TABLE STATS Statement
- SHOW COLUMN STATS Statement
- SHOW PARTITIONS Statement
- SHOW FUNCTIONS Statement
- TRUNCATE TABLE
- UPDATE
- UPSERT
- USE
- VALUES
- Optimizer Hints