FIRSTWITHTIME
This section contains reference documentation for the firstwithtime function.
Signature
Example
select FIRSTWITHTIME(group_name, __metadata$recordTimestamp, 'STRING')
from meetupRsvp value
Was this helpful?
⌘Ctrlk
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
FIRSTWITHTIME(dataColumn, timeColumn, 'dataType')
This example is based on the Streaming Quick Start.
select FIRSTWITHTIME(group_name, __metadata$recordTimestamp, 'STRING')
from meetupRsvp group_name1016303453
Was this helpful?
Was this helpful?