cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <>
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 ?


Aaron Morton
Freelance Developer

On 17/08/2012, at 11:09 AM, Mat Brown <> 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

View raw message