Scalar FunctionsDynamic / JSON Functions

jaccard_index

Return the Jaccard similarity `\|A ∩ B\| / \|A ∪ B\|` of two dynamic arrays treated as sets.

Both-empty inputs return NaN; one-empty returns 0.

Syntax

jaccard_index(set1, set2)

Prop

Type

Returns: real

print jaccard_index(dynamic([1, 2, 3]), dynamic([2, 3, 4]))

print_0 (real)
0.5

extract_json

Extract a value from a JSON string using a JSONPath expression.

pack_all

Create a property bag containing all column values.