maxburke opened a new issue, #6897:
URL: https://github.com/apache/arrow-datafusion/issues/6897
### Describe the bug
After upgrading to Datafusion 27.0.0 we noticed some of our regression tests
were failing. We bisected the commit that introduced the break to 36123ee0,
which is the fix for #6595.
### To Reproduce
The attached zip file contains a parquet file. To reproduce the issue in
datafusion-cli, run:
```
> create external table t0 stored as parquet location 'test_data.parquet';
> SELECT "day" AS "date", count(distinct "direction") AS
"num_directions" FROM t0 GROUP BY "day" ORDER BY t0."day" ASC;
```
In datafusion 26 and earlier, this will generate a result. In datafusion 27,
it generates this error message:
```
Optimizer rule 'push_down_projection' failed
caused by
Error during planning: required columns can't push down, columns: {Column {
relation: Some(Bare { table: "t0" }), name: "day" }, Column { relation: None,
name: "num_directions" }, Column { relation: None, name: "date" }}
```
[test_data.zip](https://github.com/apache/arrow-datafusion/files/11996072/test_data.zip)
### Expected behavior
_No response_
### Additional context
_No response_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
