Hive join tables on string field match

Question

Hi I am trying to Left outer join on table onto another, the matching colums are type String.

Will Hive join on matching string columns or do they need to be converted to a different datatype?

My join ON Clause looks like Select table1.para1, table2.para2 From table a left outer Join Table b On (table1.a=table2.b). A and B are strings, will this work?

Answer 1

Join on string will work. Just keep in mind that string matching will be case-sensitive.

Consider using functions like UPPER or LOWER.

For example,

select * from temp join new_temp on LOWER(temp.dept) = LOWER(new_temp.dept);