FIRST_VALUE - Amazon Kinesis Data Analytics SQL Reference
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

FIRST_VALUE

FIRST_VALUE( <value-expression>) <null treatment> OVER <window-specification>

FIRST_VALUE returns the evaluation of the <value expression> from the first row that qualifies for the aggregate. FIRST_VALUE requires the OVER clause, and is considered an Analytic Functions. FIRST_VALUE has a null treatment option defined in the following table.

Null treatment option Effect

FIRST_VALUE(x) IGNORE NULLS OVER <window-specification>

Returns first non null value of x in <window-specification>

FIRST_VALUE(x) RESPECT NULLS OVER <window-specification>

Returns first value, including null of x in <window-specification>

FIRST_VALUE(x) OVER <window-specification>

Returns first value, including null of x in <window-specification>