The Netezza Community: Error while loading data ...

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)

2 Replies Last post: Oct 23, 2009 7:23 AM by Hemant Kumar

Hemant Kumar

73 posts since
Jul 30, 2009

Currently Being Moderated

Error while loading data

Hi Folks,

Can any body help me out the reason of below error?

nzsql:MODFCTPRDHLD_2.SQL:1470: ERROR: 5134 : Not enough memory for n-squared jo
in

Regards

Hemant

Tags: nzload, netezza, enzee_universe

David Shuttleworth

224 posts since
May 14, 2008

Currently Being Moderated

1. Oct 23, 2009 6:29 AM

in response to: Hemant Kumar

Re: Error while loading data

sounds like a cartesian product join is happening - please post the SQL then we can make suggestions.

Report Abuse

Hemant Kumar

73 posts since
Jul 30, 2009

Currently Being Moderated

2. Oct 23, 2009 7:23 AM

in response to: David Shuttleworth

Re: Error while loading data

Hi David,

Thanks for finding the issue.

Hi All,

Reason behind the error was wrong join condition.

Regards

Hemant

Report Abuse

Go to original post