For similar capabilities to Amazon Timestream for LiveAnalytics, consider Amazon Timestream for InfluxDB. It offers simplified data ingestion and single-digit millisecond query response times for real-time analytics. Learn more [here](https://docs.aws.amazon.com//timestream/latest/developerguide/timestream-for-influxdb.html).

# Array functions
<a name="array-functions"></a>

Timestream for LiveAnalytics supports the following array functions.


| Function | Output data type | Description | 
| --- | --- | --- | 
|  array\$1distinct(x)  |  array  |  Remove duplicate values from the array x. <pre>SELECT array_distinct(ARRAY[1,2,2,3])</pre> Example result: `[ 1,2,3 ]`  | 
|  array\$1intersect(x, y)  |  array  |  Returns an array of the elements in the intersection of x and y, without duplicates. <pre>SELECT array_intersect(ARRAY[1,2,3], ARRAY[3,4,5])</pre> Example result: `[ 3 ]`  | 
|  array\$1union(x, y)  |  array  |  Returns an array of the elements in the union of x and y, without duplicates. <pre>SELECT array_union(ARRAY[1,2,3], ARRAY[3,4,5])</pre> Example result: `[ 1,2,3,4,5 ]`  | 
|  array\$1except(x, y)  |  array  |  Returns an array of elements in x but not in y, without duplicates. <pre>SELECT array_except(ARRAY[1,2,3], ARRAY[3,4,5])</pre> Example result: `[ 1,2 ]`  | 
|  array\$1join(x, delimiter, null\$1replacement)   |  varchar  |  Concatenates the elements of the given array using the delimiter and an optional string to replace nulls. <pre>SELECT array_join(ARRAY[1,2,3], ';', '')</pre> Example result: `1;2;3`  | 
|  array\$1max(x)  |  same as array elements  |  Returns the maximum value of input array. <pre>SELECT array_max(ARRAY[1,2,3])</pre> Example result: `3`  | 
|  array\$1min(x)  |  same as array elements  |  Returns the minimum value of input array. <pre>SELECT array_min(ARRAY[1,2,3])</pre> Example result: `1`  | 
|  array\$1position(x, element)  |  bigint  |  Returns the position of the first occurrence of the element in array x (or 0 if not found). <pre>SELECT array_position(ARRAY[3,4,5,9], 5)</pre> Example result: `3`  | 
|  array\$1remove(x, element)  |  array  |  Remove all elements that equal element from array x. <pre>SELECT array_remove(ARRAY[3,4,5,9], 4)</pre> Example result: `[ 3,5,9 ]`  | 
|  array\$1sort(x)  |  array  |  Sorts and returns the array x. The elements of x must be orderable. Null elements will be placed at the end of the returned array. <pre>SELECT array_sort(ARRAY[6,8,2,9,3])</pre> Example result: `[ 2,3,6,8,9 ]`  | 
|  arrays\$1overlap(x, y)   |  boolean  |  Tests if arrays x and y have any non-null elements in common. Returns null if there are no non-null elements in common but either array contains null. <pre>SELECT arrays_overlap(ARRAY[6,8,2,9,3], ARRAY[6,8])</pre> Example result: `true`  | 
|  cardinality(x)  |  bigint  |  Returns the size of the array x. <pre>SELECT cardinality(ARRAY[6,8,2,9,3])</pre> Example result: `5`  | 
|  concat(array1, array2, ..., arrayN)  |  array  |  Concatenates the arrays array1, array2, ..., arrayN. <pre>SELECT concat(ARRAY[6,8,2,9,3], ARRAY[11,32], ARRAY[6,8,2,0,14])</pre> Example result: `[ 6,8,2,9,3,11,32,6,8,2,0,14 ]`  | 
|  element\$1at(array(E), index)  |  E  |  Returns element of array at given index. If index < 0, element\$1at accesses elements from the last to the first. <pre>SELECT element_at(ARRAY[6,8,2,9,3], 1)</pre> Example result: `6`  | 
|  repeat(element, count)   |  array  |  Repeat element for count times. <pre>SELECT repeat(1, 3)</pre> Example result: `[ 1,1,1 ]`  | 
|  reverse(x)  |  array  |  Returns an array which has the reversed order of array x. <pre>SELECT reverse(ARRAY[6,8,2,9,3])</pre> Example result: `[ 3,9,2,8,6 ]`  | 
|  sequence(start, stop)  |  array(bigint)  |  Generate a sequence of integers from start to stop, incrementing by 1 if start is less than or equal to stop, otherwise -1. <pre>SELECT sequence(3, 8)</pre> Example result: `[ 3,4,5,6,7,8 ]`  | 
|  sequence(start, stop, step)   |  array(bigint)  |  Generate a sequence of integers from start to stop, incrementing by step. <pre>SELECT sequence(3, 15, 2)</pre> Example result: `[ 3,5,7,9,11,13,15 ]`  | 
|  sequence(start, stop)   |  array(timestamp)  |  Generate a sequence of timestamps from start date to stop date, incrementing by 1 day. <pre>SELECT sequence('2023-04-02 19:26:12.941000000', '2023-04-06 19:26:12.941000000', 1d)</pre> Example result: `[ 2023-04-02 19:26:12.941000000,2023-04-03 19:26:12.941000000,2023-04-04 19:26:12.941000000,2023-04-05 19:26:12.941000000,2023-04-06 19:26:12.941000000 ]`  | 
|  sequence(start, stop, step)   |  array(timestamp)  |  Generate a sequence of timestamps from start to stop, incrementing by step. The data type of step is interval. <pre>SELECT sequence('2023-04-02 19:26:12.941000000', '2023-04-10 19:26:12.941000000', 2d)</pre> Example result: `[ 2023-04-02 19:26:12.941000000,2023-04-04 19:26:12.941000000,2023-04-06 19:26:12.941000000,2023-04-08 19:26:12.941000000,2023-04-10 19:26:12.941000000 ]`  | 
|  shuffle(x)  |  array  |  Generate a random permutation of the given array x. <pre>SELECT shuffle(ARRAY[6,8,2,9,3])</pre> Example result: `[ 6,3,2,9,8 ]`  | 
|  slice(x, start, length)  |  array  |  Subsets array x starting from index start (or starting from the end if start is negative) with a length of length. <pre>SELECT slice(ARRAY[6,8,2,9,3], 1, 3)</pre> Example result: `[ 6,8,2 ]`  | 
|  zip(array1, array2[, ...])  |  array(row)  |  Merges the given arrays, element-wise, into a single array of rows. If the arguments have an uneven length, missing values are filled with NULL. <pre>SELECT zip(ARRAY[6,8,2,9,3], ARRAY[15,24])</pre> Example result: `[ ( 6, 15 ),( 8, 24 ),( 2, - ),( 9, - ),( 3, - ) ]`  |