apache / apache/datafusion-sqlparser-rs

Support GROUP BY ALL

Open
#791 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
Rust
Stars
3.5k
Forks
772
Avg merge
4d 9h
Merged PRs (30d)
17

Description

DuckDB supports this: https://duckdb.org/2022/05/04/friendlier-sql.html:

```
SELECT
systems,
planets,
cities,
cantinas,
SUM(scum + villainy) as total_scum_and_villainy
FROM star_wars_locations
GROUP BY ALL
-- GROUP BY systems, planets, cities, cantinas
```

It's essentially a shortcut to refer to all dimension fields in a group by.

Contributor guide

No contributing guide indexed for this repository

Research direction

Start with the DuckDB GROUP BY ALL reference linked in the issue and inspect the parser's existing GROUP BY handling; no file or test path is named. Done means the example syntax is accepted and coverage verifies that GROUP BY ALL represents grouping by all dimension fields.

Written by the indexing model from the issue text.

Assessment

Tech stack
rust, sql
Domain
compilers, databases
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.