Unsupported SQL statements in Impala

At the time of writing this book, 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. Please check Appendix, Technology Behind Impala and Integration with Third-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
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.14.251.128