Understanding the Pitfalls of Left Outer Joins in Hive: How to Optimize for Better Performance