benchmarks/sql_benchmarks/tpch/init/set_config.sql

set datafusion.optimizer.prefer_hash_join=${PREFER_HASH_JOIN:-true};

set datafusion.execution.hash_join_buffering_capacity=${HASH_JOIN_BUFFERING_CAPACITY:-0};