array_first_index

SinceVersion 2.0

array_first_index

description

Syntax

ARRAY<T> array_first_index(lambda, ARRAY<T> array1, ...)

Use an lambda expression as an input parameter to perform corresponding expression calculations on the internal data of other input ARRAY parameters. Returns the first index such that the return value of lambda(array1[i], ...) is not 0. Return 0 if such index is not found.

There are one or more parameters input in the lambda expression, and the number of elements of all input arrays must be the same. Legal scalar functions can be executed in lambda, aggregate functions, etc. are not supported.

  1. array_first_index(x->x>1, array1);
  2. array_first_index(x->(x%2 = 0), array1);
  3. array_first_index(x->(abs(x)-1), array1);
  4. array_first_index((x,y)->(x = y), array1, array2);

example

  1. mysql> select array_first_index(x->x+1>3, [2, 3, 4]);
  2. +-------------------------------------------------------------------+
  3. | array_first_index(array_map([x] -> x(0) + 1 > 3, ARRAY(2, 3, 4))) |
  4. +-------------------------------------------------------------------+
  5. |                                                                 2 |
  6. +-------------------------------------------------------------------+
  8. mysql> select array_first_index(x -> x is null, [null, 1, 2]);
  9. +----------------------------------------------------------------------+
  10. | array_first_index(array_map([x] -> x(0) IS NULL, ARRAY(NULL, 1, 2))) |
  11. +----------------------------------------------------------------------+
  12. |                                                                    1 |
  13. +----------------------------------------------------------------------+
  15. mysql> select array_first_index(x->power(x,2)>10, [1, 2, 3, 4]);
  16. +---------------------------------------------------------------------------------+
  17. | array_first_index(array_map([x] -> power(x(0), 2.0) > 10.0, ARRAY(1, 2, 3, 4))) |
  18. +---------------------------------------------------------------------------------+
  19. |                                                                               4 |
  20. +---------------------------------------------------------------------------------+
  22. mysql> select col2, col3, array_first_index((x,y)->x>y, col2, col3) from array_test;
  23. +--------------+--------------+---------------------------------------------------------------------+
  24. | col2         | col3         | array_first_index(array_map([x, y] -> x(0) > y(1), `col2`, `col3`)) |
  25. +--------------+--------------+---------------------------------------------------------------------+
  26. | [1, 2, 3]    | [3, 4, 5]    |                                                                   0 |
  27. | [1, NULL, 2] | [NULL, 3, 1] |                                                                   3 |
  28. | [1, 2, 3]    | [9, 8, 7]    |                                                                   0 |
  29. | NULL         | NULL         |                                                                   0 |
  30. +--------------+--------------+---------------------------------------------------------------------+

keywords

ARRAY,FIRST_INDEX,ARRAY_FIRST_INDEX