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

1 Answer

0 votes
by

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.

Related questions

0 votes
asked Apr 24, 2020 in Big Data | Hadoop by Hodge
0 votes
asked Apr 7, 2020 in Big Data | Hadoop by GeorgeBell
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986
...