This topic describes how to use the INSERT INTO statement in Spark Streaming SQL.
INSERT INTO tbName[(columnName[,columnName]*)] queryStatement;
INSERT INTO LargeOrders SELECT * FROM Orders WHERE units > 1000;
- Spark Streaming SQL does not allow you to use a separate SELECT statement for query. A SELECT statement must be used together with a CTAS statement or be contained in an INSERT INTO statement.
- For a single job, an SQL file can contain multiple Data Manipulation Language (DML) operations, and multiple data sources and sinks.