I bet results would be roughly the same even for the exact same dataset - Scylla and other K/v data stores can’t compete with columnar databases that are purpose built for complex analytics queries. the many orders of magnitude query performance differences (not to count storage, compute overhead) show it enough.
It was kind of a crummy use case for Scylla anyway (it’s a transactional write store, not an analytics engine)
It was kind of a crummy use case for Scylla anyway (it’s a transactional write store, not an analytics engine)