The Vertica Database Forums

Hi,

Can anyone provide me the resolution for the below mentioned error message:

Error: ERROR: Join inner did not fit in memory ((public.STG_Biz_Imr4_Distinct x OPERATIONS.FA_CHAT_PRE_CONNECT) using STG_Biz_Imr4_Distinct_proj and subquery (PATH ID: 1))
SQLState: 53200
ErrorCode: 0

Please note while running the same query on different server I am not getting any error message.

Regards,
Shaili
sbathwal@infocepts.com

Is the explain plan the same on both systems? Specifically, do they both have up to date statistics and both have the same relation chosen for the inner? Does the amount of memory on the clusters differ?

Hi Sharon,

Thanks for your quick response.

As we are new to Vertica could you please let me know where can I check these details in Vertica?

Regards,
Shaili
Sbathwal@infocepts.com

Hi,

FYI, this post discusses the same error:

viewtopic.php?f=3&t=437&start=10

shaili,

Are you still having an issue? You can run the select analyze_statistics(''); command in vsql to update your statistics.

Thanks!