Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How can I resolve this query in hiveql?

Highlighted

How can I resolve this query in hiveql?

New Contributor
Good night guys!

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?

Ex: 
Table 1 
Name 
Barack Hussein Obama II
Calvin Cordozar Broadus Jr.



Table 2 
Name 
Barack Obama II Hussein 
Cordozar Jr. Broadus Calvin