Skip to content

Latest commit

 

History

History
27 lines (18 loc) · 780 Bytes

lastwithtime.md

File metadata and controls

27 lines (18 loc) · 780 Bytes
Raw
description
This section contains reference documentation for the lastwithtime function.

LASTWITHTIME

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

Signature

LASTWITHTIME(dataColumn, timeColumn, 'dataType')

Example

This example is based on the Streaming Quick Start.

select LASTWITHTIME(group_name, __metadata$recordTimestamp, 'STRING')
from meetupRsvp
value
group_name809822304