This topic introduces common keywords used in Spark Streaming SQL and describes how to use these keywords.
Background information
EMR V3.21.0 and later provide a preview release of Spark Streaming SQL for you to develop streaming analytics jobs.
Spark Streaming SQL is developed based on Spark Structured Streaming. All syntax functions and limits are compliant with Spark Structured Streaming.
Common keywords
| Keyword type | Keyword |
|---|---|
| DDL | CREATE TABLE, CREATE TABLE AS SELECT, CREATE SCAN, CREATE STREAM |
| DML | INSERT INTO, MERGE INTO |
| SELECT clause | SELECT FROM, WHERE, GROUP BY, JOIN, UNION ALL |
Use keywords as field names
If you want to use a keyword as a field name, enclose the keyword in backticks (`) in the format of `value`.