Movatterモバイル変換

[0]ホーム
URL:

JSON_ARRAY_UNPACK

Converts an encoded blob representing a vector to a JSON array representing the same vector.

It is a scalar function.

Syntax

JSON_ARRAY_UNPACK(vector_expression)

Arguments

  • vector_expression: An expression that evaluates to a vector. The vector must be encoded as a blob containing packed single-precision or double-precision floating-point numbers in little-endian byte order.

Return Type

A JSON array of zero or more floating point numbers.

Warning

Beginning with 8.5 the blob data type will be replaced with the vector data type. Blob data types will be deprecated for vector databases.

Remarks

A vector can be of any length, but blob lengths must be divisible by 4 bytes (or 8 bytes, depending on the data type specified).

You can specify the data type of the vector elements in which this operation is performed on the vector by adding a suffix to the function. Omitting the suffix from the function is equivalent to suffixing it with_F32. All operations are done using the specified data type. The following table lists the suffixes and their data type.

Suffix

Data Type

_I8

8-bit signed integer

_I16

16-bit signed integer

_I32

32-bit signed integer

_I64

64-bit signed integer

_F32

32-bit floating-point number (IEEE standard format)

_F64

64-bit floating-point number (IEEE standard format)

Examples

The following examples use theju_t table.

CREATETABLE ju_t(xBLOB, yBLOB);
INSERTINTO ju_tVALUES(JSON_ARRAY_PACK('[12.1, 6.4]'), JSON_ARRAY_PACK('[8.6,9.2]'));
INSERTINTO ju_tVALUES(JSON_ARRAY_PACK('[5.2, 11.7]'), JSON_ARRAY_PACK('[4.6,7.3]'));

Querying Rows Using JSON_ARRAY_UNPACK

The following example queries thet table using theJSON_ARRAY_UNPACK() function:

SELECT JSON_ARRAY_UNPACK(x)"x", JSON_ARRAY_UNPACK(y)"y"from ju_t;
+-------------------------+-------------------------+| x                       | y                       |+-------------------------+-------------------------+| [12.1000004,6.4000001]  | [8.60000038,9.19999981] || [5.19999981,11.6999998] | [4.5999999,7.30000019]  |+-------------------------+-------------------------+

Typecasting the Data Type using Suffixes

The values inserted in thet table are 32-bit floating point numbers, because no suffix was specified with theJSON_ARRAY_PACK() function. The following query returns the vector blobs as 32-bit integers.

SELECT JSON_ARRAY_UNPACK_I32(x)"x", JSON_ARRAY_UNPACK_I32(y)"y"from ju_t;
+-------------------------+-------------------------+| x                       | y                       |+-------------------------+-------------------------+| [1094818202,1087163597] | [1091148186,1091777331] || [1084647014,1094398771] | [1083388723,1089051034] |+-------------------------+-------------------------+

Related Topics

Last modified: March 21, 2024

Was this article helpful?

Verification instructions

Note: You must installcosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity ofsinglestoredb-server,singlestoredb-toolbox,singlestoredb-studio, andsinglestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can runcosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click theDownload Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined|
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC\
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker\
          --bundle undefined\
          --new-bundle-format -
    Verified OK
[8]ページ先頭
©2009-2025 Movatter.jp