Last Updated: February 25, 2016
· deleteman

Always keep the larger table on the right side of joins

When doing JOINs on HIVE, remember to keep the larger size table on the right of the expression, that'll make it be streamed through the reducers, instead of being cached in memory (as does the left side table) avoiding that horrible Heap Space issue that you'll run into.