Re: Repair taking long time

2014-09-30 Thread Ben Bromhead
use https://github.com/BrianGallew/cassandra_range_repair On 30 September 2014 05:24, Ken Hancock ken.hanc...@schange.com wrote: On Mon, Sep 29, 2014 at 2:29 PM, Robert Coli rc...@eventbrite.com wrote: As an aside, you just lose with vnodes and clusters of the size. I presume you plan to

Re: best practice for waiting for schema changes to propagate

2014-09-30 Thread Ben Bromhead
The system.peers table which is a copy of some gossip info the node has stored, including the schema version. You should query this and wait until all schema versions have converged. http://www.datastax.com/documentation/cql/3.0/cql/cql_using/use_sys_tab_cluster_t.html

Re: Experience with multihoming cassandra?

2014-09-30 Thread Ben Bromhead
I'm guessing your talking about multi-homing because you want to have multiple tenants (different apps/ teams etc) to make better use of resources ? As Jared mentioned running multiple Cassandra processes on the same hardware that participate in the same cluster doesn't make much sense from a

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-30 Thread Ben Bromhead
check your cqlshrc file (sometimes in ~/.cassandra) ? I've been caught out before when playing with a RC of 2.1 On 30 September 2014 01:25, Andrew Cobley a.e.cob...@dundee.ac.uk wrote: Without the apache cassandra running I ran jps -l on this machine ,the only result was 338

Re: Not-Equals (!=) in Where Clause

2014-09-30 Thread Sylvain Lebresne
Is != supported as part of the where clause in Cassandra? It's not. Or is it the grammar for some other purpose? It's supported in 'IF' conditions. You can do something like: SELECT * FROM foo WHERE k = 0 IF v != 3; -- Sylvain

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

2014-09-30 Thread Sylvain Lebresne
On Tue, Sep 30, 2014 at 2:25 AM, Robert Coli rc...@eventbrite.com wrote: On Mon, Sep 22, 2014 at 3:50 AM, Carlos Scheidecker nando@gmail.com wrote: I can successfully read a file to a ByteBuffer and then write to a Cassandra blob column. However, when I retrieve the value of the column,

Re: Indexes Fragmentation

2014-09-30 Thread James Briggs
MySQL Cluster (don't use FKs yet) or Redis (in-memory databases) sound more appropriate for data that churns a lot. Thanks, James Briggs. -- Cassandra/MySQL DBA. Available in San Jose area or remote. cass_top: https://github.com/jamesbriggs/cassandra-top

Re: Saving file content to ByteBuffer and to column does not retrieve the same size of data

2014-09-30 Thread Andrew Cobley
I too have saved images in blobs (in development environment admittedly) . Sample code can be seen here: https://github.com/acobley/instagrim/blob/master/src/main/java/uk/ac/dundee/computing/aec/instagrim/models/PicModel.java Note this code uses the org.imgscalr.Scalr to resize and process

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-30 Thread Andrew Cobley
HI Ben, yeah, that was it, recovered from the Cassandra summit ? Andy On 30 Sep 2014, at 08:19, Ben Bromhead b...@instaclustr.commailto:b...@instaclustr.com wrote: check your cqlshrc file (sometimes in ~/.cassandra) ? I've been caught out before when playing with a RC of 2.1 On 30

Cassandra and frequent updates

2014-09-30 Thread Matthias Hübner
Hi all, i'm unsure if cassandra is appropriate for my use case: Maintain a query model. Collect data from several sources (asynchronously) and merge it into aggregates (rows) in one cassandra table. The data is mostly updated, except from initial load or adding new data ranges. Some source

Re: DSE install interfering with apache Cassandra 2.1.0

2014-09-30 Thread Ben Bromhead
Only recently! Moving off list (c* users bcc'd). On 30 September 2014 19:20, Andrew Cobley a.e.cob...@dundee.ac.uk wrote: HI Ben, yeah, that was it, recovered from the Cassandra summit ? Andy On 30 Sep 2014, at 08:19, Ben Bromhead b...@instaclustr.com wrote: check your cqlshrc

Re: Not-Equals (!=) in Where Clause

2014-09-30 Thread Tyler Hobbs
I think Sylvain may not have had his coffee yet. You can't use IF's in SELECT statements, but you can in INSERT/UPDATE/DELETE: UPDATE foo SET a = 0 WHERE k = 0 IF b != 0; On Tue, Sep 30, 2014 at 2:36 AM, Sylvain Lebresne sylv...@datastax.com wrote: Is != supported as part of the where

Re: best practice for waiting for schema changes to propagate

2014-09-30 Thread graham sanderson
Also be aware of https://issues.apache.org/jira/browse/CASSANDRA-7734 if you are using C* 2.0.6+ (2.0.6 introduced a change that can sometimes causes initial schema propagation not to happen, introducing potentially long delays until some other code path repairs it later) On Sep 30, 2014, at

Re: Cassandra and frequent updates

2014-09-30 Thread DuyHai Doan
Hello Matthias According to your description, an event-sourcing design would be a good fit for your scenario. In Cassandra, instead of updating existing data, why don't you just store new values (it can be delta only, not a problem) with a monotonic increasing date ? This way, in your