You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Drew Kutcharian <dr...@venarc.com> on 2013/02/15 02:57:55 UTC

multiget_slice using CQL3

Hi Guys,

What's the syntax for multiget_slice in CQL3? How about multiget_count?

-- Drew

Re: multiget_slice using CQL3

Posted by Drew Kutcharian <dr...@venarc.com>.

Thanks Edward. I assume I can still do a column slice using WHERE in case of wide rows. I wonder if the multiget count is the only thing that you can do using thrift but not CQL3.

On Feb 14, 2013, at 6:35 PM, Edward Capriolo <ed...@gmail.com> wrote:

> The equivalent of multget slice is
> 
> select * from table where primary_key in ('that', 'this', 'the other thing')
> 
> Not sure if you can count these in a way that makes sense since you
> can not group.
> 
> On Thu, Feb 14, 2013 at 9:17 PM, Michael Kjellman
> <mk...@barracuda.com> wrote:
>> I'm confused what you are looking to do.
>> 
>> CQL3 syntax (SELECT * FROM keyspace.cf WHERE user = 'cooldude') has
>> nothing to do with thrift client calls (such as multiget_slice)
>> 
>> What is your goal here?
>> 
>> Best,
>> michael
>> 
>> On 2/14/13 5:57 PM, "Drew Kutcharian" <dr...@venarc.com> wrote:
>> 
>>> Hi Guys,
>>> 
>>> What's the syntax for multiget_slice in CQL3? How about multiget_count?
>>> 
>>> -- Drew
>>

Re: multiget_slice using CQL3

Posted by Edward Capriolo <ed...@gmail.com>.

The equivalent of multget slice is

select * from table where primary_key in ('that', 'this', 'the other thing')

Not sure if you can count these in a way that makes sense since you
can not group.

On Thu, Feb 14, 2013 at 9:17 PM, Michael Kjellman
<mk...@barracuda.com> wrote:
> I'm confused what you are looking to do.
>
> CQL3 syntax (SELECT * FROM keyspace.cf WHERE user = 'cooldude') has
> nothing to do with thrift client calls (such as multiget_slice)
>
> What is your goal here?
>
> Best,
> michael
>
> On 2/14/13 5:57 PM, "Drew Kutcharian" <dr...@venarc.com> wrote:
>
>>Hi Guys,
>>
>>What's the syntax for multiget_slice in CQL3? How about multiget_count?
>>
>>-- Drew
>

Re: multiget_slice using CQL3

Posted by Michael Kjellman <mk...@barracuda.com>.

I'm confused what you are looking to do.

CQL3 syntax (SELECT * FROM keyspace.cf WHERE user = 'cooldude') has
nothing to do with thrift client calls (such as multiget_slice)

What is your goal here?

Best,
michael

On 2/14/13 5:57 PM, "Drew Kutcharian" <dr...@venarc.com> wrote:

>Hi Guys,
>
>What's the syntax for multiget_slice in CQL3? How about multiget_count?
>
>-- Drew