[gdal-dev] Reading from (geo)parquet using mixed spatia and non-spatiall filters

[Even Rouault]

Le 23/01/2026 à 08:32, Ari Jolma a écrit :
> Thanks Even,
>
> Attribute filter fid = <fid> seems fast but ID = <ID> is not fast. 

Probably because your features appear in random ID order, and thus the 
target ID you're looking for is in the range of ID values of most row 
groups, and thus lead to loading everything (whereas the OGR "fid" is 
sequential and thus it is easy to load only the row group containing 
it). You could try using the "PARQUET:your.parquet" connection string 
that will go through the arrow dataset API whose filtering logic 
possibly uses page statistics (which the "your.parquet" file syntax 
don't do), but this might not help a lot. There's no indices in Parquet.

-- 
http://www.spatialys.com
My software is free, but my time generally not.