Comment by adenverd

100M? Of course you'd scale an RDBMS for that, especially if you want searchability and analytics. It's way easier than a Hadoop -> Elasticsearch pipeline (or pick your flavor).

NoSQL databases are for BIG data. As in, billions of rows big.