Amazon Kinesis Data Analytics SQL Reference (original) (raw)

Note

For new projects, we recommend that you use Kinesis Data Analytics Studio over Kinesis Data Analytics for SQL Applications. Kinesis Data Analytics Studio combines ease of use with advanced analytical capabilities, enabling you to build sophisticated stream processing applications in minutes.

The Amazon Kinesis Data Analytics SQL Reference describes the SQL language elements that are supported by Amazon Kinesis Data Analytics. The language is based on the SQL:2008 standard with some extensions to enable operations on streaming data.

For information about developing Kinesis Data Analytics applications, see the Kinesis Data Analytics Developer Guide.

This guide covers the following:

• Streaming SQL Language Elements – Data Types, Streaming SQL Operators, Functions.
• Standard SQL Operators – CREATE statements, SELECT statement.
• Operators for transforming and filtering incoming data – WHERE clause, JOIN clause, GROUP BY clause,WINDOW Clause (Sliding Windows).
• Logical Operators – AS, AND, OR, etc.

Streaming SQL Language Elements

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.