This topic describes common keywords used in Spark Streaming SQL and how to use these keywords.

Common keyword types

Keyword type Keyword
DDL CREATE TABLE and CREATE TABLE AS SELECT
DML INSERT INTO
SELECT clause SELECT FROM, WHERE, GROUP BY, and JOIN

Usage

If you want to use a keyword as a field name, enclose the keyword in backticks (`), for example, `value`.