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
SQLState: 53200
Moderator: NorbertKrupa
Re: SQLState: 53200
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?
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC
Vertica Consultant, Zazz Technologies LLC
Re: SQLState: 53200
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
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
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: SQLState: 53200
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: SQLState: 53200
shaili,
Are you still having an issue? You can run the select analyze_statistics(''); command in vsql to update your statistics.
Thanks!
Are you still having an issue? You can run the select analyze_statistics(''); command in vsql to update your statistics.
Thanks!
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.