alt.hn

7/30/2026 at 2:58:07 PM

Paging Through a Parquet File in DuckDB: File_row_number or Offset?

https://rusty.today/blog/paging-parquet-duckdb-file-row-number-vs-offset/

by rustyconover

7/30/2026 at 4:19:02 PM

There's also a pseudocolumn called rowid that's worth knowing about for similar purposes but on duckdb tables:

https://duckdb.org/docs/lts/sql/statements/select#:~:text=Ro...

by RobinL

7/30/2026 at 3:55:56 PM

I'd assume it's common knowledge that you cannot paginate using OFFSET + LIMIT unless you use ORDER BY on an unique set of columns, no matter what database you're using. The only exception is when the database provides an explicit order guarantee without the ORDER BY, such as the case with `preserve_insertion_order = true` here.

by matharmin

7/30/2026 at 4:07:19 PM

Even then, that does not work if new records are being inserted.

by sroussey