adriangb commented on issue #24109:
URL: https://github.com/apache/datafusion/issues/24109#issuecomment-5195458992
@alamb I think you need the `CREATE EXTERNAL TABLE` step. I updated the
repro:
```
❯ datafusion-cli
DataFusion CLI v54.0.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.003 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.001 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 |
+----+
| 1 |
| 2 |
| 3 |
+----+
3 row(s) fetched.
Elapsed 0.001 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]
