Upsolver SQLake
Contact Support
Search
⌃
K
Links
Overview
Get started
Deploying Upsolver on AWS
Connectors
Data ingestion
Data transformation
Quickstarts
How to guides
SQL command reference
Functions and operators reference
Logical operators and filter functions
Comparison functions and operators
Conditional functions and expressions
Mathematical functions and operators
String functions and operators
Regular expression functions
Date and time functions
Interval functions
Aggregate functions
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT_EACH
AVG
AVG_EACH
AVG_TIME_SERIES
COLLECT_SET
COLLECT_SET_EACH
COUNT
COUNT(*)
COUNT(DISTINCT ...)
COUNT_EACH
COUNT_IF
DYNAMIC_SESSIONS
FIRST
FIRST_ARRAY
FIRST_EACH
FIRST_TIME_SERIES
LAST
LAST_ARRAY
LAST_EACH
LAST_K
LAST_K_EACH
LAST_TIME_SERIES
MAX
MAX_BY
MAX_EACH
MAX_TIME_SERIES
MIN
MIN_BY
MIN_EACH
MIN_TIME_SERIES
SESSION_COUNT
STD_DEV
STD_DEV_EACH
STRING_MAX
STRING_MAX_EACH
STRING_MIN_EACH
SUM
SUM_EACH
SUM_TIME_SERIES
WEIGHTED_AVERAGE
Array functions
URL functions
External APIs functions
Spatial functions
Structural functions
Type conversions functions
System Catalog
Job status
API Integration
CLI
FAQ
Troubleshooting
Upsolver cost estimate
Change log
Powered By
GitBook
Comment on page
FIRST_ARRAY
Gets the first array of values seen in the events within the time window.
Syntax
FIRST_ARRAY
(
VALUE
)
Arguments
VALUE
Type:
array
The value to return.
Returns
Type:
array
Returns the first array of values seen in the events within the time window.
Previous
FIRST
Next
FIRST_EACH
Last modified
1yr ago