Elasticsearch can't do very complex queries like postgresql can (probably needs something like spark?). Elasticsearch can't grow tables, you need to create a n

Elasticsearch can't do very complex queries like postgresql can (probably needs something like spark?). Elasticsearch can't grow tables, you need to create a new one index with more shards and transfer data. BigQuery works only in column-store while citus works in column-store + row-store (column-stores don't support update/delete). You can mix row/column-store tables and query/join them together. It is interesting because that it's latest postgres, example you can have Hyperloglog column-types, which ~none else offers. It is available as open-source wich bigquery isn't (elastic is though).