3 ms·

I think ClickHouse does that.

• nijave 6y ago
  I actually started looking at Clickhouse a couple weeks ago but got a bit side tracked trying to grok how distributed tables work. It looks promising but there's a bit of a learning curve (seems some of the performance also comes from its use of arrays but best I can tell my use case should just use regular tables)
  • hodgesrm 6y ago
    ClickHouse performance is principally due to column storage, compression, and ability to parallelize processing. Arrays can improve performance in some specific cases but are more commonly used to help deal with semi-structured data or perform custom processing on values within groups. If your data maps cleanly to tables, that's in fact the best case with the easiest options for performance enhancement.