Impala SQL Statements

The Impala SQL dialect has a number of common features as well as certain additions for Big Data use cases such as data loading and data warehousing.

Note that each statement in the impala-shell interpreter must terminate with a semicolon. This is a mandatory practice in most of the RDBMSs as well. We do not include the semicolon in the syntax specification of each statement because it is not part of the SQL syntax, but we do present it in examples designed to be run in impala-shell.

The parts below outline the most frequent SQL statements used in Impala, which are detailed in this portal’s articles.

  • DDL Statements
  • DML Statements
  • ALTER DATABASE Statement
  • ALTER TABLE Statement
  • ALTER VIEW Statement
  • COMMENT Statement
  • COMPUTE STATS Statement
  • CREATE DATABASE Statement
  • CREATE FUNCTION Statement
  • CREATE ROLE Statement (Impala 2.0 or higher only)
  • CREATE TABLE Statement
  • CREATE VIEW Statement
  • DELETE Statement (Impala 2.8 or higher only)
  • DESCRIBE Statement
  • DROP DATABASE Statement
  • DROP FUNCTION Statement
  • DROP ROLE Statement (Impala 2.0 or higher only)
  • DROP STATS Statement
  • DROP TABLE Statement
  • DROP VIEW Statement
  • EXPLAIN Statement
  • GRANT Statement (Impala 2.0 or higher only)
  • INSERT Statement
  • INVALIDATE METADATA Statement
  • LOAD DATA Statement
  • REFRESH Statement
  • REFRESH AUTHORIZATION Statement
  • REFRESH FUNCTIONS Statement
  • REVOKE Statement (Impala 2.0 or higher only)
  • SELECT Statement
  • SET Statement
  • SHOW Statement
  • SHUTDOWN Statement
  • TRUNCATE TABLE Statement (Impala 2.3 or higher only)
  • UPDATE Statement (Impala 2.8 or higher only)
  • UPSERT Statement (Impala 2.8 or higher only)
  • USE Statement
  • VALUES Statement
  • Optimizer Hints

Most of the above topics are already covered in this blog. Please go through them. Please subscribe to receive notifications about new posts.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s