Why is the Spark memory set to 2gb?

[MrPowers]

Here's the line:

tpch/queries/pyspark/utils.py

Line 24 in 6c5bbe9

.config("spark.driver.memory", settings.run.spark_driver_memory)

If these benchmarks are being run on a single node, we should probably set the shuffle partitions to be like 1-4 instead of 200 (which is the default).

[ritchie46]

@stinodego any clue?

[stinodego]

These are default values that will let you run scale factor 1 locally without any problems. If we use PySpark defaults, certain queries fail due to memory issues.

The benchmark blog has the actual values used during the benchmark:

For PySpark, driver memory and executor memory were set to 20g and 10g respectively.

I have tried a few different settings, and these seemed to work best for scale factor 10.

If these benchmarks are being run on a single node, we should probably set the shuffle partitions to be like 1-4 instead of 200 (which is the default).

Could be - I am by no means a PySpark optimization expert. Perhaps they should implement better/dynamic defaults.