Error sql out Error org apache spark SparkException Job aborted due to stage failure Total size of serialized results of 381610 tasks 4 0 GB is bigger than spark driver maxResultSize 4 0 GB

Question

Hi Guys,

I created one data frame in Spark SQL. But when I tried to collect the data it shows me the below error.

sql.out:Error: org.apache.spark.SparkException: Job aborted due to stage failure: Total size of serialized results of 381610 tasks (4.0 GB) is bigger than spark.driver.maxResultSize (4.0 GB)

How can I solve this error?

Answer 1

This type of error tends to occur when running a SQL query in Spark SQL where result set is not limited. When you run the query on a small data set, it works fine, but as soon as you run the same query on a larger data set, you would likely hit this exception. To increase to a larger limit, add the following line to spark-defaults.conf file. 

 $ spark.driver.maxResultSize 4G

Hope this will help.