VEC_ToText
The Next Generation of MariaDB: Powered by Vector Search
Watch the WebinarMariaDB starting with 11.7
Vectors were introduced in MariaDB 11.7.
Syntax
VEC_ToText(v)
Description
VEC_ToText converts a binary vector into a json array of numbers (floats). Returns NULL and throws a warning 4201 if given an invalid vector.
Example
SELECT VEC_ToText(x'e360d63ebe554f3fcdbc523f4522193f5236083d'); +---------------------------------------------------------+ | VEC_ToText(x'e360d63ebe554f3fcdbc523f4522193f5236083d') | +---------------------------------------------------------+ | [0.418708,0.809902,0.823193,0.598179,0.033255] | +---------------------------------------------------------+
Invalid vector:
SELECT VEC_ToText(x'aabbcc'); +-----------------------+ | VEC_ToText(x'aabbcc') | +-----------------------+ | NULL | +-----------------------+ 1 row in set, 1 warning (0.000 sec) Warning (Code 4201): Invalid binary vector format. Must use IEEE standard float representation in little-endian format. Use VEC_FromText() to generate it.
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
