Last reducer stuck in a Hive Query which which has Group By

[#1]

Customer has a Hive Query with a Group By Clause and is stuck on the last Reducer. This looks like a Reducer Skew in the Group By Clause.

You may please use the below said configuration in the Hive CLI at the session level.

Inside the Hive CLI.

set hive.groupby.skewindata=true;

<Run the Query>