sparksql常用优化参数
·
set spark.sql.autoBroadcastJoinThreshold = 4096;设置广播变量的阈值
set spark.driver.memory = 2g; 设置driver进程的内存,无需设置过大
set spark.num.executors = 20; 设置多少个executor用于计算,开启动态资源分配时,任务的executor数目会动态调整
set spark.executor.memory = 8g;单个executor进程的内存大小
set spark.executor.cores = 4;单个executor进程的CPU核数
set spark.default.parallelism = 120;设置任务(task)的并行度
set spark.sql.shuffle.partitions = 120;指定shuffle操作后任务的并行度
set spark.storage.memoryFraction = 0.5;指定executor进程中用于存储临时数据的内存
set spark.shuffle.memoryFraction = 0.3;指定executor进程中用于shuffle操作的内存
set spark.yarn.executor.memoryOverhead = 4096;增大executor内存,该值一般为2的次幂
更多推荐
所有评论(0)