arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

FIRSTWITHTIME

This section contains reference documentation for the firstwithtime function.

Returns the value of dataColumn with the smallest timeColumn value where:

  • timeColumn is used to define the time of dataColumn, which can be of type TIMESTAMP, INT, LONG

  • dataType specifies the type for dataColumn, which can be BOOLEAN, INT, LONG, FLOAT, DOUBLE, STRING

hashtag
Signature

FIRSTWITHTIME(dataColumn, timeColumn, 'dataType')

hashtag
Example

This example is based on the .

value

group_name1016303453

Streaming Quick Start
select FIRSTWITHTIME(group_name, __metadata$recordTimestamp, 'STRING')
from meetupRsvp