Query first 1 columns for each partitioning keys in CQL?

2014-05-16 Thread Matope Ono
Hi, I'm modeling some queries in CQL3. I'd like to query first 1 columns for each partitioning keys in CQL3. For example: create table posts( author ascii, created_at timeuuid, entry text, primary key(author,created_at) ); insert into posts(author,created_at,entry) values

Re: Query first 1 columns for each partitioning keys in CQL?

2014-05-17 Thread Matope Ono
/refClstrOrdr.html http://www.datastax.com/documentation/cql/3.1/cql/cql_reference/select_r.html Jonathan Lacefield Solutions Architect, DataStax (404) 822 3487 http://www.linkedin.com/in/jlacefield http://www.datastax.com/cassandrasummit14 On Fri, May 16, 2014 at 12:23 AM, Matope Ono

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

2016-10-14 Thread Matope Ono
Thanks to CASSANDRA-11206, I think we can have much larger partition than before 3.6. (Robert said he could treat safely 10 15GB partitions at his presentation. https://www.youtube.com/watch?v=N3mGxgnUiRY) But is there still 2B columns limit on the Cassandra code? If so, out of curiosity, I'd

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

2016-10-15 Thread Matope Ono
like 10 million columns where each column can have a data of size >> 1KB). >> >> >> >> >> >> On Fri, Oct 14, 2016 at 9:54 PM, Matope Ono <matope@gmail.com> wrote: >> >>> Thanks to CASSANDRA-11206, I think we can hav

Re: Why does Cassandra need to have 2B column limit? why can't we have unlimited ?

2016-10-15 Thread Matope Ono
ing, repair session failure in the middle that >>>>> forces you to re-send the whole big partition --> the receiving node has a >>>>> bunch of duplicate data --> pressure on compaction >>>>> - bootstrapping of new nodes --> failure to stream a

Re: GC/CPU increase after upgrading to 3.0.14 (from 2.1.18)

2017-09-26 Thread Matope Ono
Hi. We met similar situation after upgrading from 2.1.14 to 3.11 in our production. Have you already tried G1GC instead of CMS? Our timeouts were mitigated after replacing CMS with G1GC. Thanks. 2017-09-25 20:01 GMT+09:00 Steinmaurer, Thomas < thomas.steinmau...@dynatrace.com>: > Hello, > > >