Re: Cassandra Ussages

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: > >

Re: Cassandra Ussages

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,

Re: Cassandra Ussages

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

Re: Cassandra Ussages

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

Re: Cassandra Ussages

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

Re: Cassandra Ussages

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

Re: Cassandra Ussages

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

Cassandra Ussages

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