apache / apache/datafusion

feat: Support `RESET ALL` Command

Open
#21,314 1 comment 0 reactions 1 assignee Claimed by @erenavsarogullari View on GitHub
enhancement
Dominant language
Rust
Stars
9.3k
Forks
2.4k
Avg merge
3d 7h
Merged PRs (30d)
344

Description

### Is your feature request related to a problem or challenge?
Currently, DataFusion supports `RESET` Command when resetting the configuration to its default value. PostgreSQL and AWS RDS DB Engines also support `RESET ALL` Command to reset all settable run-time parameters to default values as follows:
PostgreSQL: https://www.postgresql.org/docs/current/sql-reset.html
AWS RDS: https://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_ResetDBParameterGroup.html

`RESET ALL` Command can also be useful for DataFusion to reset the configs to default values by single command as follows:
```
SET datafusion.execution.batch_size = 10000
SET datafusion.runtime.memory_limit = '1M'

RESET ALL

SHOW datafusion.execution.batch_size
datafusion.execution.batch_size 8192

SHOW datafusion.runtime.memory_limit
datafusion.runtime.memory_limit unlimited
```

This feature is follow-up to https://github.com/apache/datafusion/issues/21244.

### Describe the solution you'd like

Explained in the first section.

### Describe alternatives you've considered

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.