vector_dims()

函数说明

vector_dims 函数用于确定向量的维度。

函数语法

  1. > SELECT vector_dims(vector) AS dimension_count FROM table_name;

示例

  1. drop table if exists vec_table;
  2. create table vec_table(a int, b vecf32(3), c vecf64(3));
  3. insert into vec_table values(1, "[1,2,3]", "[4,5,6]");
  4. insert into vec_table values(2, "[7,8,9]", "[1,2,3]");
  5. mysql> select * from vec_table;
  6. +------+-----------+-----------+
  7. | a    | b         | c         |
  8. +------+-----------+-----------+
  9. |    1 | [1, 2, 3] | [4, 5, 6] |
  10. |    2 | [7, 8, 9] | [1, 2, 3] |
  11. +------+-----------+-----------+
  12. 2 row in set (0.00 sec)
  14. mysql> select vector_dims(b) from vec_table;
  15. +----------------+
  16. | vector_dims(b) |
  17. +----------------+
  18. |              3 |
  19. |              3 |
  20. +----------------+
  21. 2 row in set (0.01 sec)