Re: large range read in Cassandra

2015-02-02 Thread Dan Kinder
For the benefit of others, I ended up finding out that the CQL library I was using (https://github.com/gocql/gocql) at this time leaves paging page size defaulted to no paging, so Cassandra was trying to pull all rows of the partition into memory at once. Setting the page size to a reasonable

Re: Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Kai Wang
I would not use 2.1.2 for production yet. It doesn't seem stable enough based on the feedbacks I see here. The newest 2.0.12 may be a better option. On Feb 2, 2015 8:43 AM, Sibbald, Charles charles.sibb...@bskyb.com wrote: Hi Oleg, What is the minor version of 1.2? I am looking to do the same

Re: Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Oleg Dulin
Sure but the question is really about going from 1.2 to 2.0 ... On 2015-02-02 13:59:27 +, Kai Wang said: I would not use 2.1.2 for production yet. It doesn't seem stable enough based on the feedbacks I see here. The newest 2.0.12 may be a better option. On Feb 2, 2015 8:43 AM, Sibbald,

Re: Any problem mounting a keyspace directory in ram memory?

2015-02-02 Thread Gabriel Menegatti
Hi Colin, Yes, we don't want to use the C* in-memory, we just want to mount the keyspace data directory to RAM instead of leaving it on the spinning disks. My question is more related to the technical side of mounting the keyspace data folder to the ram memory than checking if Cassandra has

Re: Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Oleg Dulin
Our minor version is 1.2.15 ... I am not looking forward to the experience, and would like to gather as much information as possible. This presents an opportunity to also review the data structures we use and possibly move them out of Cassandra. Oleg On 2015-02-02 13:42:52 +, Sibbald,

Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Oleg Dulin
Dear Distinguished Colleagues: We'd like to upgrade our cluster from 1.2 to 2.0 and then to 2.1 . We are using Pelops Thrift client, which has long been abandoned by its authors. I've read that 2.x has changes to the Thrift protocol making it incompatible with 1.2 (and of course now the link

Re: Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Sibbald, Charles
Hi Oleg, What is the minor version of 1.2? I am looking to do the same for 1.2.14 in a very large cluster. Regards Charles On 02/02/2015 13:33, Oleg Dulin oleg.du...@gmail.com wrote: Dear Distinguished Colleagues: We'd like to upgrade our cluster from 1.2 to 2.0 and then to 2.1 . We are

RE: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-02-02 Thread Lu, Boying
Hi, Holmberg, I tried your suggestion and run the following command: keytool –exportcert –keystore path-to-my-keystore-file –storepass my-keystore-password –storetype JKS –file path-to-outptfile and I got following error: keytool error: java.lang.Exception: Alias mykey does not exist Do you

Re: Any problem mounting a keyspace directory in ram memory?

2015-02-02 Thread Gabriel Menegatti
Hi Jan, Thanks for your reply, but C* in-memory just supports 1 GB keyspaces at the moment, what is not enough for us. My question is more related to the technical side of mounting the keyspace data folder to the ram memory than checking if Cassandra has some in-memory feature. My intention

Re: Any problem mounting a keyspace directory in ram memory?

2015-02-02 Thread Hannu Kröger
At least I cannot think of any reason why it wouldn't work. As you said, you might lose the data but if you can live with that then why not. Hannu On 02.02.2015, at 14:21 , Gabriel Menegatti gabr...@s1mbi0se.com.br wrote: Hi Colin, Yes, we don't want to use the C* in-memory, we just want

Re: How to deal with too many sstables

2015-02-02 Thread 曹志富
Just run nodetool repair. The nodes witch has many sstables are newest in my cluster.Before add these nodes to my cluster ,my cluster have not compaction automaticly because my cluster is an only write cluster. thanks. -- 曹志富 手机:18611121927

Re: How to deal with too many sstables

2015-02-02 Thread 曹志富
You are right.I have already change cold_reads_to_omit to 0.0. -- 曹志富 手机:18611121927 邮箱:caozf.zh...@gmail.com 微博:http://weibo.com/boliza/ 2015-02-03 14:15 GMT+08:00 Roland Etzenhammer r.etzenham...@t-online.de: Hi, maybe you are running into an issue that

Re: How to deal with too many sstables

2015-02-02 Thread Marcus Eriksson
https://issues.apache.org/jira/browse/CASSANDRA-8635 On Tue, Feb 3, 2015 at 5:47 AM, 曹志富 cao.zh...@gmail.com wrote: Just run nodetool repair. The nodes witch has many sstables are newest in my cluster.Before add these nodes to my cluster ,my cluster have not compaction automaticly because

Re: How to deal with too many sstables

2015-02-02 Thread Flavien Charlon
Did you run incremental repair? Incremental repair is broken in 2.1 and tends to create way too many SSTables. On 2 February 2015 at 18:05, 曹志富 cao.zh...@gmail.com wrote: Hi,all: I have 18 nodes C* cluster with cassandra2.1.2.Some nodes have aboud 40,000+ sstables. my compaction strategy is

Re: Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Carlos Rolo
Using Pycassa (https://github.com/pycassa/pycassa)I had no trouble with the Clients writing/reading from 1.2.x to 2.0.x (Can't recall the minor versions out of my head right now). Regards, Carlos Juzarte Rolo Cassandra Consultant Pythian - Love your data rolo@pythian | Twitter: cjrolo |

Re: Upgrading from 1.2 to 2.1 questions

2015-02-02 Thread Oleg Dulin
What about Java clients that were built for 1.2 and how they work with 2.0 ? On 2015-02-02 14:32:53 +, Carlos Rolo said: Using Pycassa (https://github.com/pycassa/pycassa)I had no trouble with the Clients writing/reading from 1.2.x to 2.0.x (Can't recall the minor versions out of my head

Help on modeling a table

2015-02-02 Thread Asit KAUSHIK
HI All We are working on a application logging project and this is one of the search tables as below : CREATE TABLE logentries ( logentrytimestamputcguid timeuuid PRIMARY KEY, context text, date_to_hour bigint, durationinseconds float, eventtimestamputc timestamp,

Re: Help on modeling a table

2015-02-02 Thread Jack Krupansky
A leading wildcard is one of the slowest things you can do with Lucene, and not a recommended practice, so either accept that it is slow or don't do it. That said, there is a trick you can do with a reverse wildcard filter, but that's an expert-level feature and not recommended for average

Re: Help on modeling a table

2015-02-02 Thread Asit KAUSHIK
I'll try your recommendations and would update on the same Thanks so much Cheers Asit On Mon, Feb 2, 2015, 9:56 PM Eric Stevens migh...@gmail.com wrote: Just a minor observation: those field names are extremely long. You store a copy of every field name with every value with only a couple of

Re: Help on modeling a table

2015-02-02 Thread Eric Stevens
Just a minor observation: those field names are extremely long. You store a copy of every field name with every value with only a couple of exceptions: http://www.datastax.com/documentation/cassandra/1.2/cassandra/architecture/architecturePlanningUserData_t.html Your partition key column name

Re: Cassandra on Ceph

2015-02-02 Thread Eric Stevens
Colin, I'm not familiar with Ceph, but it sounds like it's a more sophisticated version of a SAN. Be aware that running Cassandra on absolutely anything other than local disks is an anti-pattern. It will have a profound negative impact on performance, scalability, and reliability of your

How to deal with too many sstables

2015-02-02 Thread 曹志富
Hi,all: I have 18 nodes C* cluster with cassandra2.1.2.Some nodes have aboud 40,000+ sstables. my compaction strategy is STCS. Could someone give me some solution to deal with this situation. Thanks. -- 曹志富 手机:18611121927 邮箱:caozf.zh...@gmail.com

Re: How to deal with too many sstables

2015-02-02 Thread Roland Etzenhammer
Hi, maybe you are running into an issue that I also had on my test cluster. Since there were almost no reads on it cassandra did not run any minor compactions at all. Solution for me (in this case) was: ALTER TABLE tablename WITH compaction = {'class': 'SizeTieredCompactionStrategy',

Re: Question about use scenario with fulltext search

2015-02-02 Thread Asit KAUSHIK
Yes but the stargate-core project is using native lucene libraries but yes it would be dependent on the stargate-core developer. I find that very easy and doing more analysis on this. Regards Asit On Mon, Feb 2, 2015 at 12:50 PM, Colin colpcl...@gmail.com wrote: I use solr and cassandra but

Re: Question about use scenario with fulltext search

2015-02-02 Thread Andres de la Peña
You can also try Stratio Cassandra, which is based in Cassandra 2.1.2, the latest version of Apache Cassandra: https://github.com/Stratio/stratio-cassandra It provides an open sourced implementation of the secondary indexes of Cassandra, which allows you to perform full-text queries, distributed

RE: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled

2015-02-02 Thread Lu, Boying
Thanks a lot ;) I’ll try your suggestions. From: Adam Holmberg [mailto:adam.holmb...@datastax.com] Sent: 2015年1月31日 1:12 To: user@cassandra.apache.org Subject: Re: FW: How to use cqlsh to access Cassandra DB if the client_encryption_options is enabled Assuming the truststore you are