2

We are evaluating embedding duckdb in our applications. We deal with a lot of tables where the columns will be around 60-70 % sparse most of the time. Does duckdb fill them with default null values or does it support sparsity internally?

user2286963
  • 125
  • 2
  • 11

1 Answers1

2

At the moment, DuckDB does not support sparsity internally. But its something that we are considering.

Update, 2023:

We have compression now that efficiently suppresses NULL storage using only a single bit. So this should now be greatly improved. –

Hannes Mühleisen
  • 2,542
  • 11
  • 13