Re: How do I add a custom comparator class to a cassandra cluster ?

On Tue, May 15, 2012 at 12:53 AM, Ertio Lew wrote: > @Brandon : I just created a jira issue to request this type of comparator > along with Cassandra. > > It is about a UTF8 comparator that provides case insensitive ordering of > columns. > See issue here : https://issues.apache.org/jira/browse/CA

Re: Does or will Cassandra support OpenJDK ?

I've used java-package under Debian (http://wiki.debian.org/JavaPackage) which turns your download from Oracle into a .deb. This may work on Ubuntu as well. On May 14, 2012, at 11:19 PM, aaron morton wrote: > To get the latest sun java 6 JRE on a ubuntu machine using apt-get I've used > the ins

Re: How do I add a custom comparator class to a cassandra cluster ?

@Brandon : I just created a jira issue to request this type of comparator along with Cassandra. It is about a UTF8 comparator that provides case insensitive ordering of columns. See issue here : https://issues.apache.org/jira/browse/CASSANDRA-4245 On Tue, May 15, 2012 at 11:14 AM, Brandon William

Re: How do I add a custom comparator class to a cassandra cluster ?

On Mon, May 14, 2012 at 1:11 PM, Ertio Lew wrote: > I need to add a custom comparator to a cluster, to sort columns in a certain > customized fashion. How do I add the class to the cluster  ? I highly recommend against doing this, because you'll be locked in to your comparator and not have an eas

Re: Counter CF and TTL

Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, May 14, 2012 at 11:43 PM, aaron morton wrote: > Counter columns do not support a TTL. > > Cheers > > -

Re: How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

I don't think this is possible, the best you can do is prefix, if your order is alphabetical. For example I have a CF with comparator UTF8Type, and then I can do slice query and bring all columns that start with the prefix, and end with the prefix where you replace the last char with the next one i

Re: How do I add a custom comparator class to a cassandra cluster ?

it can be in a separate jar with just one class. On 05/15/2012 12:29 AM, Ertio Lew wrote: Can I put this comparator class in a separate new jar(with just this single file) or is it to be appended to the original jar along with the other comparator classes? On Tue, May 15, 2012 at 12:22 AM, To

How can I implement 'LIKE operation in SQL' on values while querying a column family in Cassandra

I don't know the exact value on a column, but I want to do a partial matching to know all available values that matches. I want to do similar kind of operation that LIKE operator in SQL do. Any help is highly appreciated. -- Abhijit Chanda Software Developer VeHere Interactive Pvt. Ltd. +91-97488

Re: How do I add a custom comparator class to a cassandra cluster ?

Can I put this comparator class in a separate new jar(with just this single file) or is it to be appended to the original jar along with the other comparator classes? On Tue, May 15, 2012 at 12:22 AM, Tom Duffield (Mailing Lists) < tom.duffield.li...@gmail.com> wrote: > Kirk is correct. > > -- >

Re: cassandra initial script does not take default cluster_name

yaml is very particular about the difference between cluster_name: mycluster and cluster_name:myfluster It is also very particular about the difference between data_file_directories: - /var/lib/cassandra/data and data_file_directories: - /var/lib/cassandra/data Maybe Cassandra can switch

Re: cassandra initial script does not take default cluster_name

aaron morton thelastpickle.com> writes: > > Looks like a formatting error in the yaml file.  > Cheers > > > > - > Aaron Morton > Freelance Developer > aaronmorton > http://www.thelastpickle.com > > > > > On 15/05/2012, at 8:12 AM, jk2mhm wrote: > when I tried to start m

Re: cassandra initial script does not take default cluster_name

Looks like a formatting error in the yaml file. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/05/2012, at 8:12 AM, jk2mhm wrote: > when I tried to start my first Cassandra service instance, i got following > error > message, > > J

Re: live ratio counting

>> Are you experiencing memory pressure you think may be attributed to >> memtables not being flushed frequently enough ? > Try reducing memtable_total_space_in_mb config setting. If the problem is incorrect memory metering that should help. > i have 3 workload types running in batch. Delete o

Re: Does or will Cassandra support OpenJDK ?

To get the latest sun java 6 JRE on a ubuntu machine using apt-get I've used the instructions here https://help.ubuntu.com/community/Java#JRE_only I've also use open JDK for java 6 on ubuntu without issue. You will want to edit cassandra-env.sh to enable the jamm memory meter though, just commen

Re: Odd Node Behavior

> Most of the time, we got a few timeouts on the failover (unexpected, but not > the end of the world) and then quickly recovered; For read or write requests ? I'm guessing with 3 nodes you are using RF 3. In cassandra 1.x the read repair chance is only 10%, so 90% of the time only CL nodes are

Re: Configuring cassandra cluster with host preferences

It's not possible 'out of the box' but you could implement your own org.scale7.cassandra.pelops.pool.CommonsBackedPool.INodeSelectionStrategy that chooses the desired node. -- Dan Washusen Make big files fly visit digitalpigeon.com (http://digitalpigeon.com) On Tuesday, 15 May 2012 at 3:23 A

Re: Counter CF and TTL

Counter columns do not support a TTL. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 15/05/2012, at 12:20 AM, Tamar Fraenkel wrote: > Hi! > I saw that when Counter CF were first introduced there was no support for > TTL. >CLI does n

Re: Retrieving old data version for a given row

Cassandra does not provide access to multiple versions of the same column. It is essentially implementation detail. All mutations are written to the commit log in a binary format, see the o.a.c.db.RowMutation.getSerializedBuffer() (If you want to tail it for analysis you may want to change com

Re: get dinamicsnith info from php

I struggled with this before and decided to use HAProxy which suits my needs, you can read a little more about it at my personal blog: http://www.robinverlangen.nl/index/view/4fa902c1596cb-44a627/how-to-solve-the-pain-of-stateless-php-with-cassandra.html Good luck with it! 2012/5/14 Viktor Jevd

Re: nodetool repair requirement

Personally I would. Repair is *the* was to ensure data is fully distributed. Hinted Hand Off and Read Repair are considered optimisations designed to reduce the chance of an inconsistency during a read. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastp

Re: Cassandra Explorer - GUI for viewing Cassandra Data

Neat. Would you like to add it to the list here ? http://wiki.apache.org/cassandra/Administration%20Tools Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 13/05/2012, at 4:45 AM, shelan Perera wrote: > Hi, > > Cassandra CLI is the primar

cassandra initial script does not take default cluster_name

when I tried to start my first Cassandra service instance, i got following error message, JavaBean=org.apache.cassandra.config.Config@7c2e1f1f; No single argument constructor found for class [Ljava.lang.String; in "", line 10, column 1: cluster_name: 'testCluster' I have Java 1.6 and set

Re: cassandra 1.0.9 error - "Read an invalid frame size of 0"

Are you using framed transport on the client side ? Try the Hector user list for hector specific help https://groups.google.com/forum/?fromgroups#!searchin/hector-users Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 12/05/2012, at 5:44 A

Re: [ANN] Gossie, a Cassandra library for Go

Looks nice! On Mon, May 14, 2012 at 3:22 AM, Carlos wrote: > Hello, > > I would like to introduce you to my Go Cassandra client/library, Gossie: > > https://github.com/carloscm/gossie > > My intention was to use my favorite database with my favorite language, > with a library that allowed me to

Re: primary keys query

> So it seems it's not a good idea, to use Cassandra like that? Right. It's basically a table scan. Here is some background on the approach simple geo took to using Cassandra... http://www.readwriteweb.com/cloud/2011/02/video-simplegeo-cassandra.php Also PostGis for Postgress seems popular http:

RE: get dinamicsnith info from php

Let say you have 8 nodes cluster with replication factor 3. If one node is down, for its token range you have only 2 nodes left, not 7, which can process you requests - other nodes will forward requests to the nearest (depends on snitch) or with lower latency (depends on dynamic snitch) of 2 rem

Re: How do I add a custom comparator class to a cassandra cluster ?

Kirk is correct. -- Tom Duffield (Mailing Lists) Sent with Sparrow (http://www.sparrowmailapp.com/?sig) On Monday, May 14, 2012 at 1:41 PM, Kirk True wrote: > Disclaimer: I've never tried, but I'd imagine you can drop a JAR > containing the class(es) into the lib directory and perform a roll

Re: How do I add a custom comparator class to a cassandra cluster ?

That's right. Create class that implements the required interface and then drop that jar in lib directory and start the cluster. On Mon, May 14, 2012 at 11:41 AM, Kirk True wrote: > Disclaimer: I've never tried, but I'd imagine you can drop a JAR > containing the class(es) into the lib directory

Re: How do I add a custom comparator class to a cassandra cluster ?

Disclaimer: I've never tried, but I'd imagine you can drop a JAR containing the class(es) into the lib directory and perform a rolling restart of the nodes. On 5/14/12 11:11 AM, Ertio Lew wrote: I need to add a custom comparator to a cluster, to sort columns in a certain customized fashion. Ho

How do I add a custom comparator class to a cassandra cluster ?

I need to add a custom comparator to a cluster, to sort columns in a certain customized fashion. How do I add the class to the cluster ?

Re: DELETE from table with composite keys

Slice deletes are not supported currently. It is being worked on. https://issues.apache.org/jira/browse/CASSANDRA-3708 -Jeremiah On May 14, 2012, at 12:18 PM, Roland Mechler wrote: I have a table with a 3 part composite key and I want to delete rows based on the first 2 parts of the key. SE

Configuring cassandra cluster with host preferences

I am running my processes on the same nodes as Cassandra. What I'd like to do is when I get a connection from Pelops, it gives preference to the Cassandra node local to the host my process is on. Is it possible ? How ? Regards, Oleg Dulin Please note my new office #: 732-917-0159

Re: zabbix templates

Outstanding. Extremely helpful, thank you. On May 14, 2012, at 5:05 AM, Viktor Jevdokimov wrote: > This is, for example, Zabbix agent config for Linux based Cassandra, just > find cmdline-jmxclient-0.10.3.jar. Not all items are there, add any you need, > if missed. Start from JMX to understan

DELETE from table with composite keys

I have a table with a 3 part composite key and I want to delete rows based on the first 2 parts of the key. SELECT works using 2 parts of the key, but DELETE fails with the error: Bad Request: Missing mandatory PRIMARY KEY part part3 (see details below). Is there a reason why deleting based o

Re: live ratio counting

Are you experiencing memory pressure you think may be attributed to memtables not being flushed frequently enough ? yes especially delete workload is really good for OOM cassandra for some reason.

Re: C 1.1 & CQL 2.0 or 3.0?

This should not be the case- a keyspace is a keyspace, however created. I haven't been able to reproduce this; are you sure that the cassandra-cli and cqlsh are connecting to the same instance? Maybe you should create a Jira ticket. p On Fri, May 11, 2012 at 2:05 PM, cyril auburtin wrote: > ye

Re: FW: Cassandra Range Queries Help Needed

Hi Ansar, You'll have much better luck sending questions like this to the user mailing list (added). On Mon, May 14, 2012 at 5:42 AM, Ansar Rafique wrote: > Hi, > > I am Apache Cassandra user and currently I am working on 3 nodes cluster in > a single data center.I am using the random partitione

Re: get dinamicsnith info from php

Sorry for my bad english. I want to solve follow problem. For example we down one node for maintenance reason, for a long time (30 min). Now we use TSocketPool for polling connection to cassandra, but this poll implementation is as i think not so good, it have a custom parameter setRetryInterval,

Re: Does or will Cassandra support OpenJDK ?

Open JDK is java 1.7. Once Cassandra supports Java 1.7 it would most likely work on Open JDK, as the 1.7 Open JDK really is the same thing as Oracle JDK 1.7 without some licensed stuff. -Jeremiah On May 11, 2012, at 10:02 PM, ramesh wrote: I've had problem downloading the Sun (Oracle) JDK and

RE: get dinamicsnith info from php

I'm not sure, that selecting node upon DS is a good idea. First of all every node has values about every node, including self. Self DS values are always better than others. For example, 3 nodes RF=2: N1 N2 N3 N1 0.5ms 2ms 2ms N2 2ms 0.5ms 2ms N3 2ms 2ms 0.5ms We have monitored

get dinamicsnith info from php

Hello I want to route request from php client to minimaly loaded node, so i need dinamicsnitch info and gosip, how can i get this info fro php. Perhaps need some daemon that can communicate with cassandra gosip and translate this info to php (socket for example)???

Re: live ratio counting

liveratio calculation logic also needs to be changed because it is based on assumption that workloads do not change. Can you give an example of the sort of workload change you are thinking of ? i have 3 workload types running in batch. Delete only workload, insert only and heavy update (lot of

Odd Node Behavior

Hello, I am having some very strange issues with a cassandra setup.  I recognize that this is not the ideal cluster setup, but I'd still like to try and understand what is going wrong. The cluster has 3 machines (A,B,C) running Cassandra 1.0.9 with JNA.  A & B are in datacenter1 while C is in

Re: counter CF and TTL

Thanks *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Mon, May 14, 2012 at 3:20 PM, Viktor Jevdokimov < viktor.jevdoki...@adform.com> wrote: > There’s no TTL on counter c

Re: How to make the search by columns in range case insensitive ?

This could be accomplished with a custom 'CaseInsensitiveUTF8Type' comparator to be used as the comparator for that column family. This would require adding a class of your writing to the server. On 05/14/2012 07:26 AM, Ertio Lew wrote: I need to make a search by names index using entity name

Counter CF and TTL

> > Hi! > I saw that when Counter CF were first introduced there was no support for > TTL. > CLI does not provide TTL for counter columns. > Hector does seem to provide an interface for setting TTL > for HCounterColumn, but when I list the content of the CF I don't see the > TTL as I see for re

RE: counter CF and TTL

There's no TTL on counter columns and no ready-to-use solution I know about. https://issues.apache.org/jira/browse/CASSANDRA-2774 Best regards / Pagarbiai Viktor Jevdokimov Senior Developer Email: viktor.jevdoki...@adform.com Phone: +370 5 212 3063, Fax +3

RE: how to upgrade my cassadra from SizeTieredCompaction to LeveledCompactiom

>> There is 2T data on each server. Can someone give me some advice? > do not do it Best advice! Best regards / Pagarbiai Viktor Jevdokimov Senior Developer Email: viktor.jevdoki...@adform.com Phone: +370 5 212 3063 Fax: +370 5 261 0453 J. Jasinskio 16C, LT-01112 Vilnius, Lithuania Discla

RE: zabbix templates

This is, for example, Zabbix agent config for Linux based Cassandra, just find cmdline-jmxclient-0.10.3.jar. Not all items are there, add any you need, if missed. Start from JMX to understand, what parameters to use with keys, for example, cassandra.db.Caches[KEYSPACE,CACHE_NAME,COUNTER] ### C

How to make the search by columns in range case insensitive ?

I need to make a search by names index using entity names as column names in a row. This data is split in several rows using the first 3 character of entity name as row key & the remaining part as column name & col value contains entity id. But there is a problem, I m storing this data in a CF usi

Re: Cassandra stucks

We've not had any reported issues with connection handing, I would look for other possible reasons first. Out of interest though what OS are you using? and what is the exact JVM version ? The javax.naming.CommunicationException (http://docs.oracle.com/javase/6/docs/api/javax/naming/Communicati

Re: Behavior on inconsistent reads

What sort of corruption are you thinking about ? Whenever the first CL nodes involved in a read do not agree on the "current" value a process is run to resolve their differences. This can result in an a node that is out of sync getting repaired. Cheers - Aaron Morton Freelance

"read-update all columns" access pattern

We're on a read and update heavy access pattern. E.g. each request to Cassandra goes like 1. read all columns of row 2. do something with row 3. write all columns of row the columns we use are always the same, e.g. always (c1,c2,c3). c2 and c3 have a TTL. Since we always read c1,c2,c3 and after

Re: SSTableWriter to hdfs

Jeremy do you know the best approach here ? Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 11/05/2012, at 1:13 AM, Shawna Qian wrote: > Hi > > Can I use sstableunsortedwriter to write the data directly to hdfs or I have > to use hdfs co

Re: live ratio counting

> liveratio calc should do nothing if memtable has 0 columns. Sounds reasonable, as counting with zero columns may dramatically change the live ratio and it may take some time to be counted again. Please create a ticket on https://issues.apache.org/jira/browse/CASSANDRA > liveratio calculation l

[ANN] Gossie, a Cassandra library for Go

Hello, I would like to introduce you to my Go Cassandra client/library, Gossie: https://github.com/carloscm/gossie My intention was to use my favorite database with my favorite language, with a library that allowed me to take advantage of idiomatic Go code with the main strengths of Cassandra. I

Re: Retrieving old data version for a given row

Yes, I need this information just for academic purposes. So, to read old data values, I tried to open the Commitlog using tail -f and also the log files viewer of Ubuntu, but I can not see many informations inside of the log! Is there any other way to open this log? I didn't find any Cassandra API

Re: how to upgrade my cassadra from SizeTieredCompaction to LeveledCompactiom

> There is 2T data on each server. Can someone give me some advice? do not do it