Apache Pinot Docs
latest
Ask or search…
K
Comment on page

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

Signature

FIRSTWITHTIME(dataColumn, timeColumn, 'dataType')

Example

This example is based on the Streaming Quick Start.
select FIRSTWITHTIME(group_name, __metadata$recordTimestamp, 'STRING')
from meetupRsvp
value
group_name1016303453
Last modified 2mo ago