Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
This section contains reference documentation for the arrayConcatFloat function.
This section contains reference documentation for the arrayConcatDouble function.
This section contains reference documentation for the ADD function.
Sum of at least two values
ADD(col1, col2, col3...)
These examples are based on the Batch Quick Start.
26
37
63
This section contains reference documentation for the ago function.
Return time as epoch millis before the given period (in ISO-8601 duration format).
Examples:
"PT20.345S" -- parses as "20.345 seconds"
"PT15M" -- parses as "15 minutes" (where a minute is 60 seconds)
"PT10H" -- parses as "10 hours" (where an hour is 3600 seconds)
"P2D" -- parses as "2 days" (where a day is 24 hours or 86400 seconds)
"P2DT3H4M" -- parses as "2 days, 3 hours and 4 minutes"
"P-6H3M" -- parses as "-6 hours and +3 minutes"
"-P6H3M" -- parses as "-6 hours and -3 minutes"
"-P-6H+3M" -- parses as "+6 hours and -3 minutes"
ago()
1639150454255
This function is typically used in predicate to filter on timestamp for recent data. e.g. filter data on recent 1 day.
This section contains reference documentation for the arrayConcatString function.
Concatenates two arrays of strings.
arrayConcatString('colName1', 'colName2')
These examples are based on the Hybrid Quick Start.
N7713A,N7713A
N7713A,N7713A,N7713A,N7713A
N344AA,N344AA
N344AA,N344AA,N344AA,N344AA
N344AA,N344AA
N344AA,N344AA,N344AA,N344AA
N7713A,N7713A
N7713A,N7713A,N7713A,N7713A
This section contains reference documentation for the arrayContainsInt function.
Checks if int value exists in array.
arrayContainsInt('colName', valueToFind)
These examples are based on the Hybrid Quick Start.
13891,12892
false
14683,14683
true
12339,12339
false
13487,13930
false
13029,11292
false
This section contains reference documentation for the arrayContainsString function.
Checks if string value exists in array.
arrayContainsString('colName', valueToFind)
These examples are based on the Hybrid Quick Start.
N7713A,N7713A
true
N344AA,N344AA
false
N7713A,N7713A
true
This section contains reference documentation for the arrayDistinctInt function.
Returns unique values in an array of ints.
arrayDistinctInt('colName')
These examples are based on the Hybrid Quick Start.
15016,11066
15016,11066
10620,14869
10620,14869
13891,12892
13891,12892
12264,10397
12264,10397
11066,12892
11066,12892
This section contains reference documentation for the arrayConcatLong function.
This section contains reference documentation for the arrayConcatInt function.
Concatenates two arrays of ints.
arrayConcatInt('colName1', 'colName2')
These examples are based on the Hybrid Quick Start.
1453,1731
1453,1731,1415,1623
1908,1758
1908,1758,1339,2310
1453,1731
1453,1731,1415,1623
1908,1758
1908,1758,1339,2310
This section contains reference documentation for the arrayIndexOfInt function.
Finds the last index of the given value in the array starting at the given index.
arrayIndexOfInt('colName', valueToFind)
These examples are based on the Hybrid Quick Start.
13891,12892
-1
14683,14683
0
12339,12339
-1
13487,13930
-1
13029,11292
-1
This section contains reference documentation for the arrayReverseInt function.
Reverses array of ints.
arrayReverseInt('colName')
These examples are based on the Hybrid Quick Start.