I'm not sure you have this right. CAP says nothing about ACID - it only mentions consistency. NoSQL was in large part about precisely what the name implies - g

I'm not sure you have this right. CAP says nothing about ACID - it only mentions consistency. NoSQL was in large part about precisely what the name implies - giving up relational (SQL) data in exchange for better performance and the ability to have a distibuted store. Yes, part of this is also about being willing to trade off consistency for availability. But Elasticsearch is an example of a NoSQL store which does focus on consistency (in this case at the expense of availability and, to some extent, partition tolerance).