Hi, did you actually solve this problem. I have created a number of sandbox environments on a number of different instance sizes and once I introduce an aggregate into a Hive query I get no response. Changing the heap size got rid of the out of memory exception but aggregate queries just hang and stay at 0%.
... View more
