Amazon Kinesis Data Analytics
SQL Reference

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>