Jaccard Similarity of arrays

[alexey-milovidov]

Use case

Brute-force similarity search.

Describe the solution you'd like

See the implementation of the arrayIntersect function.

Describe alternatives you've considered

CREATE FUNCTION arrayJaccardIndex AS (a, b) -> size(arrayIntersect(a, b)) / (size(a) + size(b) - size(arrayIntersect(a, b)))

[FFFFFFFHHHHHHH]

I'd like to have a try :)