Syntax

    1. mysql> set enable_vectorized_engine=true;
    3. mysql> select k1,k2,size(k2) from array_test;
    4. +------+-----------+------------+
    5. | k1   | k2        | size(`k2`) |
    6. |    1 | [1, 2, 3] |          3 |
    7. |    2 | []        |          0 |
    9. +------+-----------+------------+
    11. mysql> select k1,k2,array_size(k2) from array_test;
    12. +------+-----------+------------------+
    13. | k1   | k2        | array_size(`k2`) |
    14. +------+-----------+------------------+
    15. |    1 | [1, 2, 3] |                3 |
    17. +------+-----------+------------------+
    19. mysql> select k1,k2,cardinality(k2) from array_test;
    20. +------+-----------+-------------------+
    21. | k1   | k2        | cardinality(`k2`) |
    22. +------+-----------+-------------------+
    23. |    1 | [1, 2, 3] |                 3 |
    24. |    2 | []        |                 0 |