Re: min_compaction_threshold/max_compaction_threshold

2012-11-03 Thread Vivek Mishra
Here is the column family script: CREATE COLUMNFAMILY "CompositeUserDataTypes" ("tweetBody" text ,"tweetDate" timestamp ,"STUDENT_ID" bigint ,"SEMESTER" text ,"STUDENT_NAME" text ,"CGPA" int ,"DIGITAL_SIGNATURE" blob ,"ENROLMENT_DATE" timestamp ,"HEIGHT" double ,"MONTHLY_FEE" double ,"JOINING_DATE

Re: repair, compaction, and tombstone rows

2012-11-03 Thread horschi
Sure, created CASSANDRA-4905. I understand that these tombstones will be still streamed though. Thats fine with me. Do you mind if I ask where you stand on making... - ... ExpiringColumn not create any tombstones? Imo this could be safely done if the columns TTL is >= gcgrace. That way it is ensur

Re: repair, compaction, and tombstone rows

2012-11-03 Thread Sylvain Lebresne
On Fri, Nov 2, 2012 at 10:46 AM, horschi wrote: > might I ask why repair cannot simply ignore anything that is older than > gc-grace? (like Aaron proposed) Well, actually the merkle tree computation could probably ignore gcable tombstones without much problem, which might not be such a bad idea a

Re: Insert via CQL

2012-11-03 Thread Sylvain Lebresne
On Sat, Nov 3, 2012 at 1:40 AM, Eric Evans wrote: > On Fri, Nov 2, 2012 at 8:09 PM, Vivek Mishra wrote: >> any idea, how to insert into a column family for a column of type "blob" via >> cql query? > > Yes, most of them involve binary data that is hex-encoded ascii. :) Unless you are using prepa

Getting all schema in 1.2.0-beta-1

2012-11-03 Thread Edward Capriolo
Using 1.2.0-beta1. I am noticing that there is no longer a single way to get all the schema. It seems like non-compact storage can be seen with show schema, but other tables are not visible. Is this by design, bug, or operator error? http://pastebin.com/PdSDsdTz