You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Courtney Robinson <sa...@live.co.uk> on 2011/04/18 02:45:09 UTC
CQL DELETE statement
Looking at the CQL spec, it doesn’t seem to be possible to delete a range of columns for a given key without specifying the individual columns to be removed, for e.g.
DELETE col1 .. col20 from CF WHERE KEY=<key|(key1,key2)>
Am I correct in thinking so or have I missed that somewhere?
Re: CQL DELETE statement
Posted by Jonathan Ellis <jb...@gmail.com>.
Transport isn't the problem.
On Mon, Apr 18, 2011 at 6:21 PM, Courtney Robinson <sa...@live.co.uk> wrote:
> Cool... Okay, the plan is to eventually not use thrift underneath, for the
> CQL stuff right?
> Once this is done and the new transport is in place, or evening while
> designing the new transport,
> is this not something that's worth looking into again? I think it'd be a
> nice feature.
>
> -----Original Message----- From: Jonathan Ellis
> Sent: Monday, April 18, 2011 3:24 AM
> To: user@cassandra.apache.org
> Cc: Tyler Hobbs
> Subject: Re: CQL DELETE statement
>
> Very old. https://issues.apache.org/jira/browse/CASSANDRA-494
>
> On Sun, Apr 17, 2011 at 7:49 PM, Tyler Hobbs <ty...@datastax.com> wrote:
>>
>> You are correct, but this is also a limitation with the Thrift API -- it's
>> not CQL specific. It turns out that deleting a slice of columns is
>> difficult. There's an old JIRA ticket somewhere that describes the
>> issues.
>>
>> On Sun, Apr 17, 2011 at 7:45 PM, Courtney Robinson <sa...@live.co.uk>
>> wrote:
>>>
>>> Looking at the CQL spec, it doesn’t seem to be possible to delete a range
>>> of columns for a given key without specifying the individual columns to
>>> be
>>> removed, for e.g.
>>> DELETE col1 .. col20 from CF WHERE KEY=<key|(key1,key2)>
>>> Am I correct in thinking so or have I missed that somewhere?
>>>
>>
>>
>> --
>> Tyler Hobbs
>> Software Engineer, DataStax
>> Maintainer of the pycassa Cassandra Python client library
>>
>>
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of DataStax, the source for professional Cassandra support
> http://www.datastax.com
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com
CQL transport (was: CQL DELETE statement)
Posted by Ted Zlatanov <tz...@lifelogs.com>.
On Tue, 19 Apr 2011 00:21:44 +0100 Courtney Robinson <sa...@live.co.uk> wrote:
CR> Cool... Okay, the plan is to eventually not use thrift underneath,
CR> for the CQL stuff right? Once this is done and the new transport is
CR> in place, or evening while designing the new transport, is this not
CR> something that's worth looking into again? I think it'd be a nice
CR> feature.
I'm assuming your question was tangential and not in the sense that
"fixing the transport will fix the reported issue."
There's https://issues.apache.org/jira/browse/CASSANDRA-2478 for a
custom non-Thrift protocol. Most of the Cassandra developers feel
HTTP+JSON or XML is inadequate for this purpose; while this may be true
for some cases, it's also true that for many of the end users HTTP+JSON
or XML is easier to support and use from a client. So I hope eventually
HTTP as the transport and JSON or XML as the serialization format are at
least an option.
Ted
Re: CQL DELETE statement
Posted by Courtney Robinson <sa...@live.co.uk>.
Cool... Okay, the plan is to eventually not use thrift underneath, for the
CQL stuff right?
Once this is done and the new transport is in place, or evening while
designing the new transport,
is this not something that's worth looking into again? I think it'd be a
nice feature.
-----Original Message-----
From: Jonathan Ellis
Sent: Monday, April 18, 2011 3:24 AM
To: user@cassandra.apache.org
Cc: Tyler Hobbs
Subject: Re: CQL DELETE statement
Very old. https://issues.apache.org/jira/browse/CASSANDRA-494
On Sun, Apr 17, 2011 at 7:49 PM, Tyler Hobbs <ty...@datastax.com> wrote:
> You are correct, but this is also a limitation with the Thrift API -- it's
> not CQL specific. It turns out that deleting a slice of columns is
> difficult. There's an old JIRA ticket somewhere that describes the
> issues.
>
> On Sun, Apr 17, 2011 at 7:45 PM, Courtney Robinson <sa...@live.co.uk>
> wrote:
>>
>> Looking at the CQL spec, it doesn’t seem to be possible to delete a range
>> of columns for a given key without specifying the individual columns to
>> be
>> removed, for e.g.
>> DELETE col1 .. col20 from CF WHERE KEY=<key|(key1,key2)>
>> Am I correct in thinking so or have I missed that somewhere?
>>
>
>
> --
> Tyler Hobbs
> Software Engineer, DataStax
> Maintainer of the pycassa Cassandra Python client library
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com
Re: CQL DELETE statement
Posted by Jonathan Ellis <jb...@gmail.com>.
Very old. https://issues.apache.org/jira/browse/CASSANDRA-494
On Sun, Apr 17, 2011 at 7:49 PM, Tyler Hobbs <ty...@datastax.com> wrote:
> You are correct, but this is also a limitation with the Thrift API -- it's
> not CQL specific. It turns out that deleting a slice of columns is
> difficult. There's an old JIRA ticket somewhere that describes the issues.
>
> On Sun, Apr 17, 2011 at 7:45 PM, Courtney Robinson <sa...@live.co.uk> wrote:
>>
>> Looking at the CQL spec, it doesn’t seem to be possible to delete a range
>> of columns for a given key without specifying the individual columns to be
>> removed, for e.g.
>> DELETE col1 .. col20 from CF WHERE KEY=<key|(key1,key2)>
>> Am I correct in thinking so or have I missed that somewhere?
>>
>
>
> --
> Tyler Hobbs
> Software Engineer, DataStax
> Maintainer of the pycassa Cassandra Python client library
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com
Re: CQL DELETE statement
Posted by Tyler Hobbs <ty...@datastax.com>.
You are correct, but this is also a limitation with the Thrift API -- it's
not CQL specific. It turns out that deleting a slice of columns is
difficult. There's an old JIRA ticket somewhere that describes the issues.
On Sun, Apr 17, 2011 at 7:45 PM, Courtney Robinson <sa...@live.co.uk> wrote:
> Looking at the CQL spec, it doesn’t seem to be possible to delete a
> range of columns for a given key without specifying the individual columns
> to be removed, for e.g.
> DELETE col1 .. col20 from CF WHERE KEY=<key|(key1,key2)>
> Am I correct in thinking so or have I missed that somewhere?
>
>
--
Tyler Hobbs
Software Engineer, DataStax <http://datastax.com/>
Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
Python client library