alamb commented on issue #24109:
URL: https://github.com/apache/datafusion/issues/24109#issuecomment-5195255051
I couldn't reproduce this
For me this came back with 1 row as expected
> SELECT id FROM fullt WHERE s['x'] = 200; -- WRONG: 3 rows
```sql
> copy (select column1 as id, column2 as s from values (1, {'x': 100, 'y':
'foo'}), (2, {'x': 200, 'y': 'foo'}),(3, {'x': 300, 'y': 'foo'}) as s ) to
'/tmp/foo.parquet';
+-------+
| count |
+-------+
| 3 |
+-------+
1 row(s) fetched.
Elapsed 0.006 seconds.
> select * from '/tmp/foo.parquet';
+----+------------------+
| id | s |
+----+------------------+
| 1 | {x: 100, y: foo} |
| 2 | {x: 200, y: foo} |
| 3 | {x: 300, y: foo} |
+----+------------------+
3 row(s) fetched.
Elapsed 0.004 seconds.
> set datafusion.execution.parquet.pushdown_filters = true;
0 row(s) fetched.
Elapsed 0.001 seconds.
> set datafusion.execution.parquet.pushdown_filters = true;
^C
> SELECT id FROM '/tmp/foo.parquet' WHERE id = 1;
+----+
| id |
+----+
| 1 |
+----+
1 row(s) fetched.
Elapsed 0.010 seconds.
> SELECT id FROM '/tmp/foo.parquet' WHERE s['x'] = 200;
+----+
| id |
+----+
| 2 |
+----+
1 row(s) fetched.
Elapsed 0.004 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]
