Scalar FunctionsDynamic / JSON Functions

jaccard_index

Return the Jaccard similarity `|A ∩ B| / |A ∪ B|` of two dynamic

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.