array_enumerate_uniq

array_enumerate_uniq

description

Syntax

ARRAY<T> array_enumerate_uniq(ARRAY<T> arr)

Returns an array the same size as the source array, indicating for each element what its position is among elements with the same value. For example, array_enumerate_uniq([1, 2, 1, 4]) = [1, 1, 2, 1]. The array_enumerate_uniq function can take multiple arrays of the same size as arguments. In this case, uniqueness is considered for tuples of elements in the same positions in all the arrays. For example, array_enumerate_uniq([1, 2, 1, 1, 2], [2, 1, 2, 2, 1]) = [1, 1, 2, 3, 2].

example

  1. mysql> select k2, array_enumerate_uniq([1, 2, 3, 1, 2, 3]);
  2. +-----------------------------------------------------+
  3. | array_enumerate_uniq(ARRAY(1, 2, 3, 1, 2, 3))       |
  4. +-----------------------------------------------------+
  5. | [1, 1, 1, 2, 2, 2]                                  |
  6. +-----------------------------------------------------+
  7. mysql> select array_enumerate_uniq([1, 1, 1, 1, 1], [2, 1, 2, 1, 2], [3, 1, 3, 1, 3]);
  8. +----------------------------------------------------------------------------------------+
  9. | array_enumerate_uniq(ARRAY(1, 1, 1, 1, 1), ARRAY(2, 1, 2, 1, 2), ARRAY(3, 1, 3, 1, 3)) |
  10. +----------------------------------------------------------------------------------------+
  11. | [1, 1, 2, 1, 3]                                                                        |
  12. +----------------------------------------------------------------------------------------+

keywords

ARRAY,ENUMERATE_UNIQ,ARRAY_ENUMERATE_UNIQ