Hash Table has grown to ..

mkkgupta · Post by **mkkgupta** » Wed Oct 21, 2009 9:41 am

Hi,

I am pulling data from TD views and it has two joins and two Aggregators.
Data is around 5-10 millon records.
I am getting Hash Table has grown warnings on Aggregator Stage.

How to avoid these warning as I am getting more than 100 warnings.

fyi. I am using a 4x4 node config file.

chulett · Post by **chulett** » Wed Oct 21, 2009 9:56 am

Post a sample of the actual unedited errors.

mkkgupta · Post by **mkkgupta** » Wed Oct 21, 2009 11:00 am

Hi Craig

Here is the warning message.

"Aggr_Extr2,0: Hash table has grown to 16384 entries. "

ArndW · Post by **ArndW** » Wed Oct 21, 2009 11:35 am

Either demote the warning message to "informational" or suppress the warning altogether; or sort your data and avoid generating the warnings in the first place. I prefer using the latter method, as that is more efficient.