How will you resolve an out of memory error while running a JOIN query?

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.

Read the full book at www.amazon.com
Posted in Hive, Hive Interview Questions

Leave a Reply

Your email address will not be published. Required fields are marked *

*