Understanding Left Outer Join with Subqueries IN/EXIST at Hive

Conditional Insertion of Values in Hive with Join Operation

Automating HIVE Queries with Shell Scripts: Looping and CSV Output