might as well go with ScyllaDB (Cassandra but not in java), but most who try suffer from wanting to reimplement sql semantics like joins

https://cassandra.apache.org/doc/stable/cassandra/data_modeling/data_modeling_rdbms.html