Re: newbie , to use cassandra when query is arbitrary?

2018-02-20 Thread Rahul Singh
Technically no. Cassandra is a NoSQL database. It is a columnar store — and so it’s not a set of relations that can be arbitrarily queried. The sstable structure is building for heavy writes and specific partook specific queries. If you need the ability for arbitrary queries you are using the

Re: newbie , to use cassandra when query is arbitrary?

2018-02-19 Thread Rajesh Kishore
Hi Rahul, I cannot confirm the size wrt Cassandra, but usually in berkley db for *10 M records* , it takes around 120 GB. Any operation takes hardly 2 to 3 ms when query is performed on index attribute. Usually 10 to 12 columns are the OOTB behaviour but one can configure any attribute to be

Re: newbie , to use cassandra when query is arbitrary?

2018-02-19 Thread Rahul Singh
What is the data size in TB / Gb and what what is the Operations Per second for read and write. Cassandra is both for high volume and high velocity for read and write. How many of the columns need to be indexed? You may find that doing a secondary index is helpful or looking to Elassandra / DSE

Re: newbie , to use cassandra when query is arbitrary?

2018-02-19 Thread Rajesh Kishore
It can be minimum of 20 m to 10 billions With each entry can contain upto 100 columns Rajesh On 19 Feb 2018 9:02 p.m., "Rahul Singh" wrote: How much data do you need to store and what is the frequency of reads and writes. -- Rahul Singh rahul.si...@anant.us

Re: newbie , to use cassandra when query is arbitrary?

2018-02-19 Thread Rahul Singh
How much data do you need to store and what is the frequency of reads and writes. -- Rahul Singh rahul.si...@anant.us Anant Corporation On Feb 19, 2018, 3:44 AM -0500, Rajesh Kishore , wrote: > Hi All, > > I am a newbie to Cassandra world, got some understanding of the

newbie , to use cassandra when query is arbitrary?

2018-02-19 Thread Rajesh Kishore
Hi All, I am a newbie to Cassandra world, got some understanding of the product. I have a application (which is kind of datastore) for other applications, the user queries are not fixed i.e the queries can come with any attributes. In this case, is it recommended to use cassandra ? What benefits