Hi Ashish,
Transactions are a big difference between Spark SQL and MemSQL/VoltDB, but
there are other differences as well. I'm not an expert on Volt, but another
difference between Spark SQL and MemSQL is that DataFrames do not support
indexes and MemSQL tables do. This will have implications for
I have used VoltDB and Spark. The use cases for the two are quite different.
VoltDB is intended for transactions and also supports queries on the
same(custom to voltdb) store. Spark(SQL) is NOT suitable for transactions; it
is designed for querying immutable data (which may exist in several
Hi Mohit,
Thanks for your reply.
If my use case is purely querying read-only data (no transaction
scenarios), at what scale is one of them a better option than the other? I
am aware that for scale which can be supported on a single node, VoltDB is
a better choice. However, when the scale grows
Hello,
I was wondering if there is any documented comparison of SparkSQL with
MemSQL/VoltDB kind of in-memory SQL databases. MemSQL etc. too allow
queries to be run in a clustered environment. What is the major
differentiation?
Regards,
Ashish