The HNG index is not recommended for GROUP BY queries..
The number of unique values is high (greater than 1000)
You don't need to do GROUP BY on the column