test_sort_1k_mem failed with too many open file error when I run locally

[jayzhan211]

Describe the bug

It has been annoyed me a while
I get this error when run locally, and the failure is not shown in CI

failures:

---- fuzz_cases::sort_fuzz::test_sort_1k_mem stdout ----
thread 'fuzz_cases::sort_fuzz::test_sort_1k_mem' panicked at datafusion/core/tests/fuzz_cases/sort_fuzz.rs:148:63:
called `Result::unwrap()` on an `Err` value: Execution("Failed to create partition file at \"/var/folders/73/gkp858j550z_tt8bx1m8k67w0000gn/T/.tmpXo6QCe/.tmpv6tET2\": Os { code: 24, kind: Uncategorized, message: \"Too many open files\" }")
note: run with `RUST_BACKTRACE=1` environment variable to display a backtrace


failures:
    fuzz_cases::sort_fuzz::test_sort_1k_mem

test result: FAILED. 23 passed; 1 failed; 0 ignored; 0 measured; 0 filtered out; finished in 11.56s

To Reproduce

cargo test --lib --tests --bins --features avro,json

Expected behavior

I expect to run the test pass locally. what setting should I use?

Additional context

No response

[mustafasrepo]

On macos I use command ulimit -S -n 2048 in the terminal to increase open file limit (Not aware of any cargo only solution).