Setting Hive in “AUTO/LOCAL MODE” comes very handy when you are dealing with small amount of data.
How this works?

Well, suppose you are running some complex hive query, then you know that it will trigger MapReduce job in background and will give you the output. 166 more words