Database Reference
In-Depth Information
Unsupported SQL statements in Impala
At the time of writing this topic, Impala's latest version, 1.1.x, does not support the
following SQL features, which are available in HiveQL:
• Nonscalar data types such as
maps
,
array
, and
struct
•
XML
and
JSON
functions
• The
LOAD DATA
statement to load raw files
• Custom UDF,
User Defined Aggregation Functions
(
UDAF
), and
User
Defined Table Generating Functions
(
UDTF
) up to Cloudera Impala 1.1.x.
party Applications
, on support for these functions in Impala 1.2.0 Beta.
• Sampling, Lateral Views, Roles, Custom SerDes, and Multiple
DISTINCT
Here is a list of
HiveQL
statements that are not supported in Impala:
•
ANALYZE TABLE
•
DESCRIBE COLUMN
•
DESCRIBE DATABASE
•
EXPORT TABLE
•
IMPORT TABLE
•
SHOW PARTITIONS
•
SHOW TABLE EXTENDED
•
SHOW TBLPROPERTIES
•
SHOW FUNCTIONS
•
SHOW INDEXES
•
SHOW COLUMNS
•
SHOW CREATE TABLE