In 1.2 there is also a -Sample file which contains a sample of -Index at the
last index_interval. This is done to (dramatically) improve startup time.
Cheers
-
Aaron Morton
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 20/04/2013, at 7
On Fri, Apr 19, 2013 at 11:36 AM, Kanwar Sangha wrote:
> Let me rephrase. I am talking about the index file on disk created per
> sstable. Does that contain all key indexes?
Yes. That's how sstablekeys can relatively efficiently produce a list
of keys, by parsing the index file.
=Rob
Let me rephrase. I am talking about the index file on disk created per sstable.
Does that contain all key indexes?
Sent from Samsung mobile
Robert Coli wrote:
On Fri, Apr 19, 2013 at 10:38 AM, Kanwar Sangha wrote:
> Guys – Quick question. The index filter file created for a sstable conta
On Fri, Apr 19, 2013 at 10:38 AM, Kanwar Sangha wrote:
> Guys – Quick question. The index filter file created for a sstable contains
> all keys/index offset for a sstable ? I know that when we bring up the node,
> it reads a sample of the keys from this file. So this file contains all k
Guys - Quick question. The index filter file created for a sstable contains all
keys/index offset for a sstable ? I know that when we bring up the node, it
reads a sample of the keys from this file. So this file contains all keys and a
sample is read on startup ?
Thanks,
Kanwar
the column index later will be inefficient.
>
>
>
> Thanks again.
>
>
>
> Regards,
>
> Vaibhav
>
>
>
> -Original Message-
> From: "aaron morton"
> Sent: Friday, January 20, 2012 12:23am
> To: user@cassandra.apache.org
> Subject: Re: CQ
gards,
Vaibhav
-Original Message-
From: "aaron morton"
Sent: Friday, January 20, 2012 12:23am
To: user@cassandra.apache.org
Subject: Re: CQL 'Where' clause ignores secondary index filter
It is working as expected.
Because you have specified a KEY the query returns rec
It is working as expected.
Because you have specified a KEY the query returns records that match that
key(s), and it ignores the other clauses.
Selecting rows follows one of three paths:
* selects rows by key(s)
* select rows by key range, i.e. rows after this key.
* select rows by (secondary
Hi,
I've defined a column family 'Vaibhav' in which every row has few columns and
its values. I've declared two column as secondary index so that I can filter
the rows on the basis of those column values.
Now whenever I execute a CQL with either only rowkey or column name in 'WHERE'
clause
