arrow-left

All pages
gitbookPowered by GitBook
1 of 1

Loading...

LASTWITHTIME

This section contains reference documentation for the lastwithtime function.

Returns the value of dataColumn with the largest 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

LASTWITHTIME(dataColumn, timeColumn, 'dataType')

hashtag
Example

This example is based on the .

value

group_name809822304

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