alamb commented on issue #24109:
URL: https://github.com/apache/datafusion/issues/24109#issuecomment-5245016665
I tried this on DataFusion 54.0.0 and I still got the same (incorrect)
answers -- so it doesn't seem to be a regression introduced in 54.
I got the correct answer using 53.0.0, so this seems to be a regression
introduced in 54
```sql
andrewlamb@Andrews-MacBook-Pro-3:~/Downloads$
~/Software/datafusion-cli/datafusion-cli-53.1.0
DataFusion CLI v53.1.0
> COPY (SELECT column1 AS id, column2 AS s, column3 AS v
FROM VALUES (1, {'x': 100, 'y': 'foo'}, 10),
(2, {'x': 200, 'y': 'foo'}, 20),
(3, {'x': 300, 'y': 'foo'}, 30))
TO '/tmp/foo.parquet' STORED AS PARQUET;
+-------+
| count |
+-------+
| 3 |
+-------+
1 row(s) fetched.
Elapsed 0.007 seconds.
> CREATE EXTERNAL TABLE fullt (id INT, s STRUCT<x INT, y VARCHAR>, v INT)
STORED AS PARQUET LOCATION '/tmp/foo.parquet';
0 row(s) fetched.
Elapsed 0.002 seconds.
> SET datafusion.execution.parquet.pushdown_filters = true;
0 row(s) fetched.
Elapsed 0.000 seconds.
> SELECT id FROM fullt WHERE v = 20;
+----+
| id |
+----+
| 2 |
+----+
1 row(s) fetched.
Elapsed 0.003 seconds.
> SELECT id FROM fullt WHERE s['x'] = 200;
+----+
| id |
+----+
| 2 |
+----+
1 row(s) fetched.
Elapsed 0.002 seconds.
```
--
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
