I want to do a query in hiveql, where I have two tables that do not contain crossover keys.
The key to be used is the name that contains the two tables, however, are names with up to 7 words, which may be in order changed.
I want to do something similar to a left join, to return only values above 93% of similarity.
How can I do this query?
Barack Hussein Obama II
Calvin Cordozar Broadus Jr.
Barack Obama II Hussein
Cordozar Jr. Broadus Calvin