LAST_ARRAY

Returns the last array of values seen in events within the time window. Unlike LAST_K this aggregation will not aggregate values across different events.

Syntax

LAST_ARRAY(VALUE)

Arguments

VALUE: An expression of any type. ‌

Returns

The result is an array of the same type as VALUE.

Example

Data

[
   {
      "id":1,
      "name":"Jimmy",
      "emails":[
         "[e-mail]",
         "[e-mail]"
      ]
   }{
      "id":2,
      "name":"Peter",
      "emails":[
         "[e-mail]"
      ]
   }{
      "id":1,
      "name":"Jimmy",
      "emails":[
         "[e-mail]",
         "[e-mail]"
      ]
   }{
      "id":3,
      "name":"Link",
      "emails":[
         
      ]
   }
]

Query:

Display the latest contents of a field for each key:

SELECT
   data.id AS id:BIGINT,
   LAST_ARRAY(data.emails[]) AS last_array_data_emails:STRING 
FROM
   "FIRST_ARRAY_DATA" 
GROUP BY
   data.id

Results:

{
   "id":2,
   "last_array_data_emails":[
      "[e-mail]"
   ]
}{
   "id":3
}{
   "id":1,
   "last_array_data_emails":[
      "[e-mail]",
      "[e-mail]"
   ]
}

Related Functions

LAST_K FIRST_ARRAY

Dialog