What is Outer Join in Hive? and how many types of Outer Joins are there?

Question

Q:

Outer Join

Outer Join helps to find out nonmatches in the tables being joined.

Let's check out the types:

1. Left outer Join.
2. Right Outer Join
3. Full outer Join.