Re: unsubscribe

2011-01-06 Thread Robert Coli
On Thu, Jan 6, 2011 at 10:52 PM, Nichole Kulobone wrote: > [ unsubscribe ] http://wiki.apache.org/cassandra/FAQ#unsubscribe " Q : How do I unsubscribe from the email list? A : Send an email to user-unsubscr...@cassandra.apache.org " =Rob

Re: quick question about super columns

2011-01-06 Thread Arijit Mukherjee
Thanx to both of you. I can now go ahead a bit more. Arijit On 7 January 2011 12:53, Narendra Sharma wrote: > With raw thrift APIs: > > 1. Fetch column from supercolumn: > > ColumnPath cp = new ColumnPath("ColumnFamily"); > cp.setSuper_column("SuperColumnName"); > cp.setColumn("ColumnName"); > C

Re: quick question about super columns

2011-01-06 Thread Narendra Sharma
With raw thrift APIs: 1. Fetch column from supercolumn: ColumnPath cp = new ColumnPath("ColumnFamily"); cp.setSuper_column("SuperColumnName"); cp.setColumn("ColumnName"); ColumnOrSuperColumn resp = client.get(getByteBuffer("RowKey"), cp, ConsistencyLevel.ONE); Column c = resp.getColumn(); 2. Add

Re: The CLI sometimes gets 100 results even though there are more, and sometimes gets more than 100

2011-01-06 Thread Stu Hood
What version of Cassandra were you testing with? On Wed, Jan 5, 2011 at 6:11 AM, David Boxenhorn wrote: > The CLI sometimes gets only 100 results (even though there are more) - and > sometimes gets all the results, even when there are more than 100! > > What is going on here? Is there some logic

Re: quick question about super columns

2011-01-06 Thread Roshan Dawrani
On Fri, Jan 7, 2011 at 12:12 PM, Arijit Mukherjee wrote: > Thank you. And is it similar if I want to search a subcolumn within a > given supercolumn? I mean I have the supercolumn key and the subcolumn > key - can I fetch the particular subcolumn? > > Can you share a small piece of example code fo

unsubscribe

2011-01-06 Thread Nichole Kulobone

Re: quick question about super columns

2011-01-06 Thread Arijit Mukherjee
Thank you. And is it similar if I want to search a subcolumn within a given supercolumn? I mean I have the supercolumn key and the subcolumn key - can I fetch the particular subcolumn? Can you share a small piece of example code for both? I'm still new into this and trying to figure out the Thrif

Re: quick question about super columns

2011-01-06 Thread Roshan Dawrani
On Fri, Jan 7, 2011 at 11:39 AM, Arijit Mukherjee wrote: > Hi > > I've a quick question about supercolumns. > EventRecord = { >eventKey2: { >e2-ts1: {set of columns}, >e2-ts2: {set of columns}, >... >e2-tsn: {set of columns} >} > > } > > If I want to

quick question about super columns

2011-01-06 Thread Arijit Mukherjee
Hi I've a quick question about supercolumns. Say I've a structure like this (based on the supercolumn family structured mention in WTF is a SuperColum): EventRecord = { eventKey1: { e1-ts1: {set of columns}, e1-ts2: {set of columns}, ... e1-tsn: {set of columns

Re: Newbie question - logsandra Flume Sink plugin.

2011-01-06 Thread Tyler Hobbs
Hi Derek, The Cassandra sink currently only works with Cassandra 0.7, although I don't suppose that is what is causing the 'InvalidSink' problem. What version of Flume are you using? The plugin works with Flume 0.9.1, but for 0.9.2 they upgraded the Thrift library version that the project uses a

Newbie question - logsandra Flume Sink plugin.

2011-01-06 Thread Deeter, Derek
Hi - I'm not sure if this should be asked on the Cassandra or Flume list, so I'm trying both - I am trying to do a proof of concept for logging into Cassandra. We need to capture large volumes of audit events in a non-lossy manner at the same time being able to quickly access those events fo

Re: Reclaim deleted rows space

2011-01-06 Thread Jonathan Shook
I believe the following condition within submitMinorIfNeeded(...) determines whether to continue, so it's not a hard loop. // if (sstables.size() >= minThreshold) ... On Thu, Jan 6, 2011 at 2:51 AM, shimi wrote: > According to the code it make sense. > submitMinorIfNeeded() calls doCompaction(

Re: unsubscribe

2011-01-06 Thread Brandon Williams
http://wiki.apache.org/cassandra/FAQ#unsubscribe

unsubscribe

2011-01-06 Thread rambabu pakala

Re: cassandra 0.7.0 noob question

2011-01-06 Thread Narendra Sharma
The schema is not loaded from cassandra.yaml by default. You need to either load it through jconsole or define it through CLI. Please read following page for details: http://wiki.apache.org/cassandra/LiveSchemaUpdates Also look for "Where are my keyspaces" on following page: http://wiki.apache.org

Re: cassandra 0.7.0 noob question

2011-01-06 Thread CassUser CassUser
Cassandra doesn't load any keyspaces by default. You have to manually do it once. Using loadSchemaFromYAML method exposed by JMX On Thu, Jan 6, 2011 at 2:00 PM, felix gao wrote: > Hi all, > > I started cassandra with very thing untouched in the conf folder, when I > examine the cassandra.yaml

cassandra 0.7.0 noob question

2011-01-06 Thread felix gao
Hi all, I started cassandra with very thing untouched in the conf folder, when I examine the cassandra.yaml file, there seems to be a default keyspace defined like below. keyspaces: - name: Keyspace1 replica_placement_strategy: org.apache.cassandra.locator.SimpleStrategy replicatio

Re: maven cassandra plugin

2011-01-06 Thread Stephen Connolly
already doing that - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense words and other nonsense are a direct result of using swype to type on the screen On 6 Jan 2011 21:09, "Ran Tavory" wrote:

Re: maven cassandra plugin

2011-01-06 Thread Stephen Connolly
fine by me - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense words and other nonsense are a direct result of using swype to type on the screen On 6 Jan 2011 21:40, "Jonathan Ellis" wrote: > We're planning to clean out contrib: > https://issues.apache.org/jira

Re: maven cassandra plugin

2011-01-06 Thread Stephen Connolly
testers welcome - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense words and other nonsense are a direct result of using swype to type on the screen On 6 Jan 2011 20:45, "B. Todd Burruss" wrote: > would u like some testers? we were about to write one. > > On 0

Re: maven cassandra plugin

2011-01-06 Thread Stephen Connolly
capistrano is a different use case. the maven plugin is for integration testing, not live deployment - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense words and other nonsense are a direct result of using swype to type on the screen On 6 Jan 2011 21:32, "shimi

Re: maven cassandra plugin

2011-01-06 Thread B. Todd Burruss
starting cassandra within maven is very useful (needed) for automated integration testing. however, i'm interested in deployment tools as well On 01/06/2011 01:32 PM, shimi wrote: I use Capistrano for install, upgrades, start, stop and restart. I use it for other projects as well. It is very

Re: maven cassandra plugin

2011-01-06 Thread Jonathan Ellis
We're planning to clean out contrib: https://issues.apache.org/jira/browse/CASSANDRA-1805 Maybe tools? On Thu, Jan 6, 2011 at 2:43 PM, Stephen Connolly wrote: > I nearly have one ready... > > my plan is to have it added to contrib... if the cassandra devs agree > > -stephen > > - Stephen > > ---

Re: maven cassandra plugin

2011-01-06 Thread shimi
I use Capistrano for install, upgrades, start, stop and restart. I use it for other projects as well. It is very useful for automated tasks that needs to run on multiple machines Shiy On 2011 1 6 21:38, "B. Todd Burruss" wrote: has anyone created a maven plugin, like cargo for tomcat, for autom

Re: maven cassandra plugin

2011-01-06 Thread Ran Tavory
Stephen, just FYI cassandra cannot be stopped cleanly. It's jvm must be taken down. So the plugin would need to probably fork a jvm and kill it when it's done. On Thursday, January 6, 2011, B. Todd Burruss wrote: > > > > > > > would u like some testers?  we were about to write one. > > On

Re: maven cassandra plugin

2011-01-06 Thread B. Todd Burruss
would u like some testers? we were about to write one. On 01/06/2011 12:43 PM, Stephen Connolly wrote: I nearly have one ready... my plan is to have it added to contrib... if the cassandra devs agree -stephen - Stephen --- Sent from my Android phone, so random spelling mistakes, random no

Re: maven cassandra plugin

2011-01-06 Thread Stephen Connolly
I nearly have one ready... my plan is to have it added to contrib... if the cassandra devs agree -stephen - Stephen --- Sent from my Android phone, so random spelling mistakes, random nonsense words and other nonsense are a direct result of using swype to type on the screen On 6 Jan 2011 19:38,

Re: How can I correct this Cassandra load imbalance?

2011-01-06 Thread ian douglas
Thanks Richard! strings UserGameshareData-*-Index.db | grep ':' | wc -l Node 1: strings/grep/wc: 979,123 space used: 2,061,497,786 Node 2: strings/grep/wc: 443,558 space used: 854,213,778 Node 3: strings/grep/wc: 2,103,294 space used: 4,505,048,405 On 01/06/2011 11:43 AM, Robert Coli wrote:

Re: How can I correct this Cassandra load imbalance?

2011-01-06 Thread Robert Coli
On Thu, Jan 6, 2011 at 10:50 AM, ian douglas wrote: > Is there any way to determine via a "nodetool cfstats" (or similar) how many > rows we have per column family to help answer your second question a little > better? In 0.6, you can get an (inexact, but probably sufficient for this purpose) est

maven cassandra plugin

2011-01-06 Thread B. Todd Burruss
has anyone created a maven plugin, like cargo for tomcat, for automating starting/stopping a cassandra instance?

Re: How can I correct this Cassandra load imbalance?

2011-01-06 Thread ian douglas
We're currently on 0.6.0 waiting for the full release of 0.7 before we upgrade. We have other Thrift/PHP code to update whenever we upgrade Cassandra, so we don't want to upgrade to a release candidate on our production system. We *did* have a problem with a column family setup where we had fe

Re: How can I correct this Cassandra load imbalance?

2011-01-06 Thread Peter Schuller
> I posted row sizes (min/max/mean) of our largest data set in my original > message, but had zero responses on the mailing list. The folks in IRC told > me to wait it out, see if to rebalanced on its own (it didn't), or to run a > repair on each node one at a time (didn't help), and that it wasn't

Re: SSTable files not getting deleted

2011-01-06 Thread Ching-Cheng Chen
Yes, those SSTable files has "compacted" tag. Those with compacted tag have size 0, so disk space is not an issue. However, the matching Filter, Index, Statistics files were not removed, either. So I ended up with tons of file under data directory although they not using much space. I'm running

Re: How can I correct this Cassandra load imbalance?

2011-01-06 Thread ian douglas
Hi Peter, I posted row sizes (min/max/mean) of our largest data set in my original message, but had zero responses on the mailing list. The folks in IRC told me to wait it out, see if to rebalanced on its own (it didn't), or to run a repair on each node one at a time (didn't help), and that it

Re: SSTable files not getting deleted

2011-01-06 Thread Robert Coli
On Thu, Jan 6, 2011 at 7:59 AM, Ching-Cheng Chen wrote: > I performed a nodetool compact, all went good and finished.   All column > family now only have one big live SSTable file. > Then I use jconsole to force a GC, but those old SSTable files still not > getting deleted.   I thought this shoul

Re: How can I correct this Cassandra load imbalance?

2011-01-06 Thread Peter Schuller
> I've been lurking in the #cassandra IRC channel lately looking for help on > this, but wanted to try the mailing list as well. Was this resolved off-list, and if so what was the problem? I don't see a problem in your description to explain the imbalance, assuming you don't have extreme variatio

Re: Join equivalent in cassandra

2011-01-06 Thread ruslan usifov
Great thanks!! 2011/1/6 Jonathan Ellis > > http://maxgrinev.com/2010/07/12/do-you-really-need-sql-to-do-it-all-in-cassandra/ > > On Thu, Jan 6, 2011 at 9:34 AM, ruslan usifov > wrote: > > Hello, > > > > Dear community please share your receipts how you implements sql joi

SSTable files not getting deleted

2011-01-06 Thread Ching-Cheng Chen
My impression is that force GC should have deleted the SSTable files no longer valid. I performed a nodetool compact, all went good and finished. All column family now only have one big live SSTable file. Then I use jconsole to force a GC, but those old SSTable files still not getting deleted.

Re: Join equivalent in cassandra

2011-01-06 Thread Jonathan Ellis
http://maxgrinev.com/2010/07/12/do-you-really-need-sql-to-do-it-all-in-cassandra/ On Thu, Jan 6, 2011 at 9:34 AM, ruslan usifov wrote: > Hello, > > Dear community please share your receipts how you implements sql joins in > cassandra? In may case we have a list of news which can be in multiple >

Join equivalent in cassandra

2011-01-06 Thread ruslan usifov
Hello, Dear community please share your receipts how you implements sql joins in cassandra? In may case we have a list of news which can be in multiple rubrics. How select news in partial rubric. Which is the best solutions?

Re: Reclaim deleted rows space

2011-01-06 Thread shimi
According to the code it make sense. submitMinorIfNeeded() calls doCompaction() which calls submitMinorIfNeeded(). With minimumCompactionThreshold = 1 submitMinorIfNeeded() will always run compaction. Shimi On Thu, Jan 6, 2011 at 10:26 AM, shimi wrote: > > > On Wed, Jan 5, 2011 at 11:31 PM, Jon

Re: Reclaim deleted rows space

2011-01-06 Thread shimi
On Wed, Jan 5, 2011 at 11:31 PM, Jonathan Ellis wrote: > Pretty sure there's logic in there that says "don't bother compacting > a single sstable." No. You can do it. Based on the log I have a feeling that it triggers an infinite compaction loop. > On Wed, Jan 5, 2011 at 2:26 PM, shimi wrote

Re: Reclaim deleted rows space

2011-01-06 Thread shimi
Am I missing something here? It is already possible to trigger major compaction on a specific CF. On Thu, Jan 6, 2011 at 4:50 AM, Tyler Hobbs wrote: > Although it's not exactly the ability to list specific SSTables, the > ability to only compact specific CFs will be in upcoming releases: > > htt

[ANN] Cassandra 0.7.0-rc4 available from Maven Central Repository

2011-01-06 Thread Stephen Connolly
Hi All, Cassandra 0.7.0-rc4 is now available from the Maven Central Repository. Apache Maven - org.apache.cassandra cassandra-all 0.7.0-rc4 Apache Ivy - Groovy Grape - @Grapes( @Grab(group='org.apache.cassandra',