array_enumerate

SinceVersion 1.2.0

array_enumerate

description

Syntax

ARRAY<T> array_enumerate(ARRAY<T> arr)

Returns array sub item indexes eg. [1, 2, 3, …, length (arr) ]

example

1. mysql> create table array_type_table(k1 INT, k2 Array<STRING>) duplicate key (k1)
2. -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
3. mysql> insert into array_type_table values (0, []), ("1", [NULL]), ("2", ["1", "2", "3"]), ("3", ["1", NULL, "3"]), ("4", NULL);
4. mysql> set enable_vectorized_engine = true;    # enable vectorized engine
5. mysql> select k2, array_enumerate(k2) from array_type_table;
6. +------------------+-----------------------+
7. | k2               | array_enumerate(`k2`) |
8. +------------------+-----------------------+
9. | []               | []                    |
10. | [NULL]           | [1]                   |
11. | ['1', '2', '3']  | [1, 2, 3]             |
12. | ['1', NULL, '3'] | [1, 2, 3]             |
13. | NULL             | NULL                  |
14. +------------------+-----------------------+
15. 5 rows in set (0.01 sec)

keywords

ARRAY,ENUMERATE,ARRAY_ENUMERATE