What data store should I use for storing and querying a billion small (~2kb) JSON documents?
1
vote
0
answers
139
views
I'm trying to figure out which database to use for storing and querying on ~1 billion JSON documents about the size of 2KB each. About 2 TB of data.
Nature of JSON documents:
* 3 types of documents (structure is loosely defined)
* Nested, multi level, sparse
Things that I'm looking for are:
* High throughput
* Secondary indexes support
* Queries over JSON
Nice to haves:
* SQL like query interface
Things I'm looking at:
* Cassandra
* Storing JSON in Postgres
* Riak
* HBase
If more details I missed regarding usage or the data I missed that would help make the decision, please let me know
Asked by Akshit Khurana
(111 rep)
Jun 7, 2017, 12:40 AM