Dropping & Creating Column Families Never Returns

2011-02-15 Thread Bill Speirs
Has anyone ever tried to drop a column family and/or create one and have the command not return from the cli? I'm using 0.7.1 and I tried to drop a column family and the command never returned. However, on another node it showed it was gone. I Ctrl-C out of the command, then issued a create for a c

Re: How to store news lists in optimal way?

2011-02-11 Thread Bill Speirs
I don't know enough about Lucene to comment, but option #2 seems like a bad idea. You shouldn't grow your database by the number of Column Families as there are bad implications to doing this. Option #1 or #3 seems plausible depending upon how much data you have. Hope this helps... Bill- On Fri,

Re: Super Slow Multi-gets

2011-02-11 Thread Bill Speirs
Sorry, I was setting the file on my client not the server. I will make this change and get back to you. Thanks again for the help... Bill- On Feb 10, 2011 4:45 PM, "Bill Speirs" wrote: > Doesn't seem to help, I just get a bunch of messages that look like this: > > DEBUG

Re: Super Slow Multi-gets

2011-02-10 Thread Bill Speirs
th my other setting... Bill- On Thu, Feb 10, 2011 at 4:37 PM, Aaron Morton wrote: > Assuming cassandra 0.7 in log4j-server.properties make it look like this... > log4j.rootLogger=DEBUG,stdout,R > > > A > On 11 Feb, 2011,at 10:30 AM, Bill Speirs wrote: > > I switched my implem

Re: Super Slow Multi-gets

2011-02-10 Thread Bill Speirs
this and I'm not seeing these messages: log4j.appender.stdout=org.apache.log4j.ConsoleAppender log4j.appender.stdout.layout=org.apache.log4j.SimpleLayout log4j.category.org.apache=DEBUG, stdout log4j.category.me.prettyprint=DEBUG, stdout Thanks... Bill- On Thu, Feb 10, 2011 at 12:53 PM, B

Re: Super Slow Multi-gets

2011-02-10 Thread Bill Speirs
n overhead of the bandwidth? > > Regards, > Utku > > On Thu, Feb 10, 2011 at 5:00 PM, Bill Speirs wrote: > >> I have a 7 node setup with a replication factor of 1 and a read >> consistency of 1. I have two column families: Messages which stores >> millions of rows w

Re: Super Slow Multi-gets

2011-02-10 Thread Bill Speirs
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Does any of that mean anything to anyone? Thanks... Bill- On Thu, Feb 10, 2

Super Slow Multi-gets

2011-02-10 Thread Bill Speirs
I have a 7 node setup with a replication factor of 1 and a read consistency of 1. I have two column families: Messages which stores millions of rows with a UUID for the row key, DateIndex which stores thousands of rows with a String as the row key. I perform 2 look-ups for my queries: 1) Fetch the

Re: time to live rows

2011-02-07 Thread Bill Speirs
I don't think this is supported (but I could be completely wrong). However, I'd love to see this functionality as well. How would one go about requesting such a feature? Bill- On Mon, Feb 7, 2011 at 4:15 PM, Kallin Nagelberg wrote: > Hey, > > I have read about the new TTL columns in Cassandra 0

Re: Sorting in time order without using TimeUUID type column names

2011-02-05 Thread Bill Speirs
You can specify reverse order through the API when you slice the cols so I don't think you need to write a comparator. Bill- On Feb 4, 2011 9:45 PM, "Aditya Narayan" wrote: Thanks Aaron, Yes I can put the column names without using the userId in the timeline row, and when I want to retrieve the

Row Key Types

2011-02-01 Thread Bill Speirs
What is the type of a Row Key? Can you define how they are compared? I ask because I'm using TimeUUIDs as my row keys, but when I make a call to get a range of row keys (get_range in phpcassa) I have to specify the UTF8 range of '' to '----' instead of the TimeUUID

Re: Probelms with Set on Byte type New Installation

2011-01-26 Thread Bill Speirs
the column family. > > Thanks what I get for continuing to work late into the night! > > Thanks, > > DQ   <  Less stupid next time > > -----Original Message- > From: Bill Speirs [mailto:bill.spe...@gmail.com] > Sent: Wednesday, January 26, 2011 4:09 PM > To: u

Re: Schema Design

2011-01-26 Thread Bill Speirs
I have a basic understanding of OPP... if most of my messages come within a single hour then a few nodes could be storing all of my values, right? You totally lost me on, "whether to shard data as per system..." Is my schema (one column family per system, and row keys as TimeUUIDType) sharding by

Re: Schema Design

2011-01-26 Thread Bill Speirs
start column as  X and end  column as Y. > Then you can use the stored column name to know when an event  occurred. > > On Wed, Jan 26, 2011 at 2:56 PM, Bill Speirs wrote: >> >> I'm looking to use Cassandra to store log messages from various >> systems. A log me

Re: Probelms with Set on Byte type New Installation

2011-01-26 Thread Bill Speirs
gt; timestamp=1296071774549000) > => (column=537461746550726f76, value=5343, timestamp=1296071760213000) > Returned 5 results. > > Values should be Name and Address Values. > > -David Q > > -Original Message- > From: Bill Speirs [mailto:bill.spe...@gmail.com] >

Schema Design

2011-01-26 Thread Bill Speirs
I'm looking to use Cassandra to store log messages from various systems. A log message only has a message (UTF8Type) and a data/time. My thought is to create a column family for each system. The row key will be a TimeUUIDType. Each row will have 7 columns: year, month, day, hour, minute, second, an

RE: Probelms with Set on Byte type New Installation

2011-01-26 Thread Bill Speirs
I'm very (2 days) new to Cassandra, but what does the output look like? Total shot in the dark, if the number is less than 256 would it not look the same as bytes or a number? Hope that in some way helps... Bill- From: David Quattlebaum [mailto:dquat...@medprocure.com] Sent: Wednesday, January