Hello Jack
What do you mind with "the map datatype with string key values effectively
gives you extensible columns"
Regards
On Tue, Mar 1, 2016 at 1:34 PM, Jack Krupansky
wrote:
> OLAP using Cassandra and Spark:
>
> http://www.slideshare.net/EvanChan2/breakthrough-olap-performance-with-cassandr
Thanks all for the tips,
Mainly we are replacing an OLAP cube, but our engine works fine with RDBMS
directly so with the low latency of cassandra it could work nice
(extensibility of this is what worries me).
We will give a try to Cassandra + Spark
Thanks again!!
On Tue, Mar 1, 2016 at 2:59 PM, J
I would spin it as Cassandra being the right choice where your primary need
in OLTP and with a secondary need for analytics. IOW, where you would
otherwise need to use two separate databases for the same data.
-- Jack Krupansky
On Tue, Mar 1, 2016 at 12:40 PM, Jonathan Haddad wrote:
> Spark &
Spark & Cassandra work just fine together, but, as I said, Cassandra is
*primarily* used for OLTP. If your main use case is analytics, I would use
something that's built for analytics. If 90%+ of your queries are going to
be 1-10ms & customer facing, then you're good to go. If you're building
so
OLAP using Cassandra and Spark:
http://www.slideshare.net/EvanChan2/breakthrough-olap-performance-with-cassandra-and-spark
What is the cardinality of your cube dimenstions? Obviously any
multi-dimensional data must be flattened.
Cassandra tables have fixed named columns, but... the map datatype w
Jonathan thanks for the link,
I believe that maybe is good as Data Store part, because is fast for I/o
and handles Time Series, for analytics could be with Apache Ignite and/or
Apache Spark
what it worries me is that looks very complex create the structure for each
Fact table and then extend
regar
Cassandra is primarily used as an OLTP database, not analytics. You should
watch this 30 min video discussing Cassandra core concepts (coming from a
relational background):
https://academy.datastax.com/courses/ds101-introduction-cassandra
On Sun, Feb 28, 2016 at 5:40 AM Andrés Ivaldi wrote:
> Hel
Hello, At my work we are looking for new technologies for an Analysis
Engine, and we are evaluating differents technologies one of them is
Cassandra as our Data repository.
Now we can execute query analysis agains an OLAP Cube and RDBMS, using
MSSQL as our data repository. Cube is obsolete and SQL
