LAST
aggregation function to select the last value of a field within a time window. This can also be used to look up user information that is stored in a user data table—that is, given the USER_ID
, look up the USER_DETAIL
, USER_DETAIL2
, and so on.USER_ID
).
The matching field in data stream (A) is selected automatically.LAST(USER_ID)
LAST(USER_DETAIL1)
LAST(USER_DETAIL2)
JOIN
statement (it can appear as part of a WITH
statement or inline).