Re: Deletes, null values

2013-04-29 Thread aaron morton
> I thought that C* had no null values... I use a lot of CF in which only the > columns name are filled up and I request a range of column to see which > references (like 1228#16866) exists. So I would like those column to simply > disappear from the table. Cassandra does not store null values.

Re: Deletes, null values

2013-04-29 Thread Alain RODRIGUEZ
I created it almost a year ago with cassandra-cli. Now show_schema returns: create column family myCF with column_type = 'Standard' and comparator = 'UTF8Type' and default_validation_class = 'UTF8Type' and key_validation_class = 'UTF8Type' and read_repair_chance = 0.1 and dclocal_read_

Re: Deletes, null values

2013-04-28 Thread aaron morton
What's your table definition ? >> select '1228#16857','1228#16866','1228#16875','1237#16544','1237#16553' >> from myCF where key = 'all'; The output looks correct to me. CQL table return values, including null, for all of the selected columns. Cheers - Aaron Morton Freelance C

Re: Deletes, null values

2013-04-26 Thread Sorin Manolache
On 2013-04-26 11:55, Alain RODRIGUEZ wrote: Of course: From CQL 2 (cqlsh -2): delete '183#16684','183#16714','183#16717' from myCF where key = 'all'; And selecting this data as follow gives me the result above: select '1228#16857','1228#16866','1228#16875','1237#16544','1237#16553' from myCF

Re: Deletes, null values

2013-04-26 Thread Alain RODRIGUEZ
I copied the wrong query: In CQL 2 it was: delete '1228#16857','1228#16866','1228#16875' from myCF where key = 'all'; Sorry about the mistake. 2013/4/26 Alain RODRIGUEZ > Of course: > > From CQL 2 (cqlsh -2): > > delete '183#16684','183#16714','183#16717' from myCF where key = 'all'; > > And

Re: Deletes, null values

2013-04-26 Thread Alain RODRIGUEZ
Of course: >From CQL 2 (cqlsh -2): delete '183#16684','183#16714','183#16717' from myCF where key = 'all'; And selecting this data as follow gives me the result above: select '1228#16857','1228#16866','1228#16875','1237#16544','1237#16553' from myCF where key = 'all'; >From thrift (phpCassa cl

Re: Deletes, null values

2013-04-25 Thread Sorin Manolache
On 2013-04-25 11:48, Alain RODRIGUEZ wrote: Hi, I tried to delete some columns using cql2 as well as thrift on C*1.2.2 and instead of being unreachable, deleted columns have a null value. I am using no value in this CF, the only information I use is the existence of the column. So when I select

Deletes, null values

2013-04-25 Thread Alain RODRIGUEZ
Hi, I tried to delete some columns using cql2 as well as thrift on C*1.2.2 and instead of being unreachable, deleted columns have a null value. I am using no value in this CF, the only information I use is the existence of the column. So when I select all the column for a given key I have the foll