Supported SQL Language Features
IMPORTANT This component is deprecated. Hewlett Packard
Enterprise recommends using an alternate product. For more information, see Discontinued Ecosystem Components.
The Impala SQL dialect supports many standard SQL language features and some extensions for Hadoop related to data loading and data warehousing. The impala-shell interpreter supports multi-line commands. A semicolon at the end of each statement is required.
SQL Features
Impala supports the following SQL features:
- Comments
- External/Internal tables
- Hints
- Joins
- Views
Statements
Impala supports the following SQL statements:
- ALTER TABLE
- CASCADE
- CREATE DATABASE
- CREATE TABLE
- CREATE TABLE AS SELECT
- CREATE VIEW
- DESCRIBE
- DROP DATABASE
- DROP TABLE/ALTER TABLE DROP PARTITION
- EXPLAIN
- INSERT
- INVALIDATE METADATA
- LOAD DATA
- PURGE
- REFRESH
- SELECT
- SHOW
- SHOW DATABASES
- TRUNCATE TABLE
- USE
Clauses
Impala supports the following SQL clauses:
- IF EXISTS
- WHRRE
- VALUES
- WITH
- GROUP BY
- HAVING
- LIMIT
- ORDER BY
Operators
Impala supports the following SQL operators:
- BETWEEN
- DISTINCT
- ILIKE
- IREGEXPR
- IS [NOT] DISTINCT FROM
- LIKE
- REGEXP
- RLIKE
Functions
Impala supports the following SQL functions:
- AVG
- BITAND
- BITNOT
- BITOR
- BITXOR
- BTRIM
- CHR
- COT
- COUNT
- COUNTSET
- CUME_DIST
- DCEIL
- DEXP
- DFLOOR
- DLOG10
- DPOW
- DROUND
- DSQRT
- DTRUNC
- FACTORIAL
- FPOW
- GETBIT
- GROUP_CONCAT
- INT_MONTHS_BETWEEN
- MAX
- MIN
- MONTHS_BETWEEN
- NDV
- NTILE
- PERCENT_RANK
- REGEXP_LIKE
- ROTATELEFT
- ROTATERIGHT
- SETBIT
- SHIFTLEFT
- SHIFTRIGHT
- SPLIT_PART
- SUM
- TIMEOFDAY
- TIMESTAMP_CMP
- TYPEOF
Data Types
Impala supports the following SQL data types:
- BIGINT
- BOOLEAN
- DECIMAL
- DOUBLE
- FLOAT
- INT
- SMALLINT
- NULL
- STRING
- TIMESTAMP
- TINYINT
Impala supports the following complex data types:
- STRUCT
- ARRAY
- MAP