cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Omitting empty columns from CQL SELECT
Date Fri, 17 Aug 2012 09:06:59 GMT
If you specify the columns by name in the select clause the query returns them because they
should be projected in the result set. 

Can you use a column slice instead ?

Cheers

-----------------
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com

On 17/08/2012, at 11:09 AM, Mat Brown <mat@brewster.com> wrote:

> Hello all,
> 
> I've noticed that when performing a SELECT statement with a list of
> columns specified, Cassandra returns all columns in the resulting
> row(s) even if they have no value. This creates an apparently
> considerable amount of transport and deserialization overhead,
> particularly in one use case I'm looking at, in which we select a
> large collection of columns but expect only a small fraction of them
> to contain values. Is there any way to get around this and only
> receive columns that have values in the results?
> 
> Thanks,
> Mat


Mime
View raw message