Can you explain how the hive query works behind the scenes.? I know there are a series of MR jobs which the hive query gets translated to, but I think there is more that I need to know the internal working of give queries.
valid question