search

spiraldb / vortex

An extensible, state-of-the-art columnar file format
https://vortex.dev
Apache License 2.0
987 stars 27 forks source link

Define null ordering #723

Open robert3005 opened 2 months ago

robert3005 commented 2 months ago

Are nulls largest or smallest? Likely largest per defaults in SQLite, Postgres and Snowflake. Do we need to be able to override this behaviour?

a10y commented 2 months ago

https://github.com/apache/arrow-rs/blob/master/arrow-ord/src/rank.rs#L25-L48

Arrow does smallest by default, most do largest by default. In Arrow it's configurable