Categories

Jan 12 in Big Data | Hadoop
Q: How will you resolve an out of memory error while running a JOIN query?

1 Answer

Jan 12

In case of JOIN query with large tables, we have a lot of data in memory. This  can cause out of memory error.

One simple solution for handling this error is to change the RIGHT OUTER JOIN  to LEFT OUTER

 

JOIN. We should try to put the table with a large number of rows on the rightmost side in a JOIN query.

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Madanswer
Jan 11 in Big Data | Hadoop
May 31 in JAVA
May 31, 2019 in NoSQL - Database Revolution
...