Skip to content

the functions array_distance, l2_distance, unnest not yet implemented #3888

Description

@l1t1

List Function Reference says
array_distance
Compute the Euclidean distance between two lists. Both lists must be the same length and cannot contain NULLs.

Example: l2_distance([1.0, 1.0], [2.0, 4.0])

Output: 3.1622776601683795

l2_distance
Compute the Euclidean distance between two lists. Both lists must be the same length and cannot contain NULLs.

Example: l2_distance([1.0, 1.0], [2.0, 4.0])

Output: 3.1622776601683795

list_extract
Extract an item from the list. Used 1-based indexing.

Example: list_extract([4,5,6], 2)

Output: 5

unnest
Converts a list into a table with one row per list element.

only the list_extract function works in v25.5.13.

glaredb> select l2_distance([1.0, 1.0], [2.0, 4.0]);
Not yet implemented: reduce
glaredb> select array_distance([1.0, 1.0], [2.0, 4.0]);
Not yet implemented: reduce
glaredb> select unnest([2.0, 4.0]);
Not yet implemented: plan unnest

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions