spark-sql运行脚本报错 tasks bigger than bigger than spark.driver.maxResult

spark-sql执行脚本，导出数据的脚本爆出如下异常；

Caused by: org.apache.spark.SparkException:Job aborted due to stage failure: Total size of serialized results of 1212tasks (10300 MB) is bigger than spark.driver.maxResultSize (1024.0 MB)

异常原因：executore传给driver端的数据量，超出了限制。spark.driver.maxResultSize默认大小是1G

解决方法：通过参数调整maxResultSize的限制值，spark.driver.maxResultSize=2g

具体异常图片如下