MapR 5.0 Documentation : Supported SQL Language Features

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.

The following list provides the major statements, clauses, and other SQL language features that you can use in Impala:

  • ALTER TABLE Statement
  • AVG Function
  • BETWEEN Operator
  • BIGINT Data Type
  • BOOLEAN Data Type
  • Comments
  • COUNT Function
  • CREATE DATABASE Statement
  • CREATE ROLE Statement
  • CREATE TABLE Statement
  • CREATE VIEW Statement
  • DECIMAL Data Type
  • DESCRIBE Statement
  • DISTINCT Operator
  • DOUBLE Data Type
  • DROP DATABASE Statement
  • DROP ROLE Statement
  • DROP TABLE Statement
  • EXPLAIN Statement
  • External Tables
  • FLOAT Data Type
  • GRANT
  • GROUP BY Clause
  • GROUP_CONCAT Function
  • HAVING Clause
  • Hints
  • INSERT Statement
  • INT Data Type
  • Internal Tables
  • INVALIDATE METADATA Statement
  • Joins
  • LIKE Operator
  • LIMIT Clause
  • LOAD DATA Statement
  • MAX Function
  • MIN Function
  • NDV Function
  • NULL
  • ORDER BY Clause
  • REFRESH Statement
  • REGEXP Operator
  • REVOKE
  • RLIKE Operator
  • SELECT Statement
  • SHOW Statement
  • SMALLINT Data Type
  • STRING Data Type
  • SUM Function
  • TIMESTAMP Data Type
  • TINYINT Data Type
  • USE Statement
  • VALUES Clause
  • Views
  • WITH Clause