Find rows without a column

Hi, It doesn't look like this is possible, but can I select all rows missing a certain column? The equivalent of "select * where col is null" in SQL. Regards, Jeff

Re: MurmurHash NPE during compaction

Thanks Aaron. Created a ticket https://issues.apache.org/jira/browse/CASSANDRA-4367 Funnny thing is, I don't see any of the SSTables that participated in the failed compaction. Will do an upgradesstables and find out if problem still persists On Mon, Jun 18, 2012 at 6:43 AM, aaron morton wrote

Column names overhead

What is the penalty for using longer column names? Should I sacrifice longer self-explanatory names for shorter cryptic ones to save the disk space? On one hand, I understand that Cassandra row id a key-value map, but on another hand, it probably uses compression when storing them. _

composite key

Hi, I have a column family like: CREATE COLUMN FAMILY Clients WITH key_validation_class = 'CompositeType(LongType,LongType)' -- master_id,client_id AND comparator = UTF8Type AND column_metadata = [ {column_name: client_name, validation_class: UTF8Type,index_type: KEYS} ]; Th

Fat Client Commit Log

Hi All, We are using the Fat Client and notice that there are files written to the commit log directory on the Fat Client. Does anyone know what these files are storing? Are these hinted handoff data? The Fat Client has no files in the data directory, as expected. thanks

Sudden massive counter increments on node restart

Hi guys, Cassandra: 1.1.1 Size: 6, even token distribution, random partitioner JVM 1.6.0_31 kernel: 2.6.32-71.el6.x86_64 24 cores, 96 GB RAM each We're seeing something pretty distressing in our cluster. When a node is brought down using "nodetool drain" and then brought back up, some of our coun

Re: Find rows without a column

On 06/22/2012 03:57 AM, Jeff Williams wrote: Hi, It doesn't look like this is possible, but can I select all rows missing a certain column? The equivalent of "select * where col is null" in SQL. Regards, Jeff remember that there really is no such thing as a row, just arbitrary columns assoc

One node hammered?

So trying to understand why I'm seeing one or two nodes getting hammered when I have a batch job running. By "hammered" I mean Disk IO load is at or near 100% and CPU load is around 10.0-17.0 while the vast majority of my nodes have a CPU load between 1-2. The node(s) hammered seems to move aroun

Re: composite key

On Fri, Jun 22, 2012 at 11:49 AM, Juan Ezquerro wrote: > Hi, > > I have a column family like: > > CREATE COLUMN FAMILY Clients > WITH key_validation_class = 'CompositeType(LongType,LongType)' -- > master_id,client_id > AND comparator = UTF8Type > AND column_metadata = [ > {column

Re: composite key

Hi I think you can use an ordered partitioner to store the rows in order, then, you can refer to the implementation of openTSDB which solves the timeseries data using composite key in Hbase. schema design in openTSDB: http://opentsdb.net/schema.html On Sat, Jun 23, 2012 at 9:51 AM, Derek Willia