Hi,
I want to create Index on already existing table which has more than 3
GB/node.
We are using c*-2.1.17 with 2 DCs , each DC with 3 groups and each group
has 7 nodes.(Total 42 nodes in cluster)
So is it ok to create Index on this table now or will it have any problem?
If its ok , how much time
We have a CF with an indexed column 'type', but we get incomplete results when
we query that CF for all rows matching 'type'. We can find the missing rows if
we query by key.
* we are seeing this on a small, single node, 1.2.2 instance with few rows.
* we use thrift execute_cql_query, no CL i
Anyone know if secondary index performance should be in the 100-500 ms range.
That's what we're seeing right now when doing lookups on a single value. We've
increased keys_cached and rows_cached to 100% for that column family and assume
that the secondary index gets the same at
Hi there,
Where can I find information regarding secondary indexes? Spent the
past 2 days looking for some good details.
http://wiki.apache.org/cassandra/SecondaryIndexes doesn't yet exist,
althought it's referenced from
http://wiki.apache.org/cassandra/StorageConfiguration
Trying to understand
Hi - I was reading some blogs on implementation of secondary indexes in
Cassandra and they say that "the read requests are sent sequentially to all the
nodes" ?
So if I have a query to fetch ALL records with the secondary index filter, will
the co-ordinator node send the requests to
If you’re only creating index so that your query work, think again! You’ll be
storing secondary index on each node , queries involving index could create
issues (slowness!!) down the road the when index on multiple node Is involved
and not maintained! Tables involving a lot of inserts/delete
oo like
select * from ks1.cf1 where id1=123 and status=0;
How can I achieve this w/o secondary index (on 'status' column )??
On Tue, Jun 20, 2017 at 12:09 AM, ZAIDI, ASAD A wrote:
> If you’re only creating index so that your query work, think again!
> You’ll be storing secondary i
to
> table(partition) will happen based on id2 i.e values(id1,id2,resp,status)
>
> I want to have a filtering/criteria applied on 'status' column too like
> select * from ks1.cf1 where id1=123 and status=0;
>
> How can I achieve this w/o secondary index (on 'status
id1, id2)
>> ) WITH CLUSTERING ORDER BY (id2 ASC)
>>
>> 'status' will have values of 0/1/2/3/4 (4 possible values) , insertions
>> to table(partition) will happen based on id2 i.e values(id1,id2,resp,status)
>>
>> I want to have a filtering/criteria applied o
Hey there –
Like other suggested before adding more index , look for opportunity to
de-normalize your data model OR create composite keys for your primary index –
if that works for you.
Secondary index are there so you can leverage them they come with cost. They’re
difficult to manage , as you
rtunity to
> de-normalize your data model OR create composite keys for your primary
> index – if that works for you.
>
> Secondary index are there so you can leverage them they come with cost.
> They’re difficult to manage , as you repair data your secondary index will
> NOT be
Hi,
beyond scope of your question (as you use 2.1.17) but starting from v3.4 SASI
is avaialble, doc is about DSE, but is applicable for free version as well.
Best regards, Vladimir Yudovin,
Winguzone - Cloud Cassandra Hosting
On Mon, 19 Jun 2017 14:00:40 -0400 techpyaasa .
Thanks for the reply vladimir but we can't upgrade c* binary that soon as
we have a quick requirement for the use case I said in my first mail.
So just wanted to know the difference between the 2 queries I asked in my
last mail
1. select * from ks1.cf1 where status=1;
2. select * from ks1.cf1 wh
>>
>>
>> Like other suggested before adding more index , look for opportunity to
>> de-normalize your data model OR create composite keys for your primary
>> index – if that works for you.
>>
>> Secondary index are there so you can leverage them they come wi
hi,
we have an CF which is about 2 gb in size, it has a seondary index on
one field (UUID).
the index has a size on disk of about 10 gb. it only shrinks a little
when forcing a compaction through jmx.
if i use sstabledump i see a lot of these:
"partition" : {
"key" : [ "123c50d1-
Hi,
I have a secondary index for a column family which is connected to a
keyspace that spans over three data centers. I observed that the index is
not complete on one of the data centers. Reason for that conclusion is, I
tried to retrieve an object, using the secondary index, in DC1 and it was a
This could be either of the following bugs (which might be the same thing). I
get it too every time I recycle a node on 1.1.10.
https://issues.apache.org/jira/browse/CASSANDRA-4973
or
https://issues.apache.org/jira/browse/CASSANDRA-4785
/Janne
On Mar 15, 2013, at 23:24 , Brett Tinling wrote:
Brett,
Do you have some steps to reproduce the problem ? If so please create a
ticket on jira.
Cheers
-
Aaron Morton
Freelance Cassandra Consultant
New Zealand
@aaronmorton
http://www.thelastpickle.com
On 16/03/2013, at 11:40 AM, Janne Jalkanen wrote:
>
> This coul
Aaron,
No recipe yet. It pops up randomly and, i think due to the nature of our app,
goes away.
Seems like when we have updates that are large (10k rows in one mutate) the
problem is more likely to occur.
I'll try to workout a repro...
-Brett
On Mar 18, 2013, at 10:18 AM, aaron morton wrote
> Seems like when we have updates that are large (10k rows in one mutate) the
> problem is more likely to occur.
10K rows in one mutate is a very bad idea.
It will take the nodes a long time to process them, risking time out, and it
will essentially starving other requests.
You should also sp
We are using CL ONE for mutates.
As for the large batches, yes, our use pattern has exceeded the initial
understanding. We plan to rewrite this bit, but it has not been a problem so
far (or maybe this index thing is the problem that forces the rewrite?). On
the rare timeout, we retry...
I h
On Jul 3, 2011, at 4:29 PM, Jeremy Hanna wrote:
> Anyone know if secondary index performance should be in the 100-500 ms range.
> That's what we're seeing right now when doing lookups on a single value.
> We've increased keys_cached and rows_cached to 100% for t
On Sun, Jul 3, 2011 at 5:12 PM, Jeremy Hanna wrote:
> Trying some other stuff with tools mentioned here:
> http://spyced.blogspot.com/2010/01/linux-performance-basics.html but not
> seeing anything particularly disk bound, though await (from iostat -x) seems
> high on one of the devices.
Are y
> Is the assumption that rows/keys cached is inherited correct? Is there any
> way to see cfstats on secondary index sub-column families?
They are inherited, but AFAIK only at the time the secondary index is created.
You would need to drop and re-create the secondary index to see it
Hi,
I have few questions:
*Secondary index*
1. Is there a limit on the number of columns in a single column family
that serve as secondary indexes?
2. Does performance decrease (significantly) if the uniqueness of the
column’s values is high?
*Twissandra*
1. Why in the source
Hello,
As mentioned by Ed Anuff in his blog and slides, one way to build customized
secondary index is:
We use one CF, each row to represent a secondary index, with the secondary
index name as row key.
For example,
Indexes = {
"User_Keys_By_Last_Name" : {
"adams" :
Hi All,
I have created KS & CF using cassandra-0.7.8 and inserted some
rows and column values(around 1000 rows). Later, I wanted to index 2
column values. So, I issued 'update column family..' command. After,
when I query based on indexed value it says "Row does not found".
After indexing 1. Iss
Hi,
is it possible to sort results based on secondary index search?
Typical use case is to get most recent comments from specified group
CF: comments
* SI: group
* SI: timestamp
I've asked before, but I can't still found any information.
Thanks
--
Petr Odut [petr.o...@gmail.com]
http://www.datastax.com/blog/whats-new-cassandra-07-secondary-indexes
On Fri, Jan 28, 2011 at 7:15 AM, Sasha Dolgy wrote:
> Hi there,
>
> Where can I find information regarding secondary indexes? Spent the
> past 2 days looking for some good details.
>
> http://wiki.apache.org/cassandra/Seconda
Thank you. So, after reading, I'm still unsure if this feature will
afford me a larger benefit when compared to an inverted index
solution.
Has anyone done a pros / cons ?
-sd
On Fri, Jan 28, 2011 at 3:22 PM, Jake Luciani wrote:
> http://www.datastax.com/blog/whats-new-cassandra-07-secondary-
Dear Sasha,
I am currently thinking about using secondary index in the future. I have
seen two pros :
_Simplicity, it is "more simple" to query based on a second index than going
for a first column then a second.
_ "Consistency" : depending on where you store your inver
Just trying to understand if secondary indexes degrade the the core
benefits of cassandra
On Fri, Jan 28, 2011 at 3:43 PM, Victor Kabdebon
wrote:
> Dear Sasha,
>
> I am currently thinking about using secondary index in the future. I have
> seen two pros :
> _Simplicity, it is "more
an 28, 2011 at 3:43 PM, Victor Kabdebon
wrote:
Dear Sasha,
I am currently thinking about using secondary index in the future. I have
seen two pros :
_Simplicity, it is "more simple" to query based on a second index than going
for a first column then a second.
_ "Consistency" : de
HI,
Is there a way to get only the keys of indexed rows (without getting
columns) using get_indexed_slices method?
I am using Hector to access Cassandra and I want to count rows with a
specific index - so i need to get only the keys.
I am doing the following:
n = 0
while (true) {
i
Hi,
I'm trying to add a new secondary index on a CF which already have a secondary
index by calling "update column family".
But the CF was left with just the new secondary index and the old index
disappeared. AFAIK, the only way to keep both indices was to include the old
sec
I tried the tutorial on this site -
http://www.datastax.com/docs/0.7/data_model/secondary_indexes and worked on
creating an index on a new column. That went good. But when I indexed an
existing column, my query below returns 0 row where in fact it should return 1.
Query:
get users where state
Hi all,
I'm trying to search by the secondary index of cassandra with "greater than
or equal". but reached an exception stating:
me.prettyprint.hector.api.exceptions.HInvalidRequestException:
InvalidRequestException(why:No indexed columns present in index clause with
operator EQ
I have a three-node cluster running Cassandra 1.0.10. In this cluster
is a keyspace with RF=3. I *updated* a column family via Astyanax to
add a column definition with an index on that column. Then I ran a
backfill to populate the column in every row. Then I tried to query
the index from Java a
e.org>"
mailto:user@cassandra.apache.org>>
Subject: Secondary Index Question
Hi – I was reading some blogs on implementation of secondary indexes in
Cassandra and they say that “the read requests are sent sequentially to all the
nodes” ?
So if I have a query to fetch ALL records with
Hi,
We are interested in secondary index implementation of Cassandra. What are
the classes that we need to approach in order to get an understanding on
secondary index implementation.
We could download and setup the basic configuration to run Cassandra.We
also could setup Cassandra as a project
:user@cassandra.apache.org>"
mailto:user@cassandra.apache.org>>
Subject: Secondary Index Question
Hi - I was reading some blogs on implementation of secondary indexes in
Cassandra and they say that "the read requests are sent sequentially to all the
nodes" ?
So if I have a query t
>
>
>-Original Message-
>From: Hiller, Dean [mailto:dean.hil...@nrel.gov]
>Sent: 21 August 2013 07:36
>To: user@cassandra.apache.org
>Subject: Re: Secondary Index Question
>
>Yup, there are other types of indexing like that in PlayOrm which do it
>differently so all n
can return the desired results ?
>
>
>-Original Message-
>From: Hiller, Dean [mailto:dean.hil...@nrel.gov]
>Sent: 21 August 2013 07:36
>To: user@cassandra.apache.org
>Subject: Re: Secondary Index Question
>
>Yup, there are other types of indexing like that in PlayOrm whi
ALL records with the secondary index filter,
> will the co-ordinator node send the requests to nodes one by one ?
>
Stock disclaimer about Cassandra Secondary Indexes :
Unless you actually need the feature of atomic update of the secondary
index with the base row, you are probably better off
Hi,
I'm using Cassandra 2.2.5 with a custom secondary index. It's created with the
below syntax:
https://docs.datastax.com/en/cql/3.1/cql/cql_reference/create_index_r.html
CREATE CUSTOM INDEX ON users (email) USING 'path.to.the.IndexClass' WITH
OPTIONS = {'some_settin
Hi, could you please clarify: 100k tombstone limit for SE is per CF,
cf-node, original sstable or (very unlikely) partition?
Thanks!
--
Oleg Krayushkin
Hi,
even after reading much about secondary index usage I'm not sure if I
have the correct use case for it.
My table will contain about 150'000'000 records (each about 2KB data).
There are two uuids used to identify a row. One uuid is unique for each
row, the other uuid is s
What's the C* version do you use? Sounds like the secondary index is very
out of sync with the parent cf.
On Fri, Mar 2, 2018 at 6:23 AM, Malte Krüger
wrote:
> hi,
>
> we have an CF which is about 2 gb in size, it has a seondary index on one
> field (UUID).
>
> the inde
We use 3.11.0 on Linux.
What's the C* version do you use? Sounds like the secondary index is very
out of sync with the parent cf.
On Fri, Mar 2, 2018 at 6:23 AM, Malte Krüger
wrote:
hi,
we have an CF which is about 2 gb in size, it has a seondary index on one
field (UUID).
the inde
I have a table with a timestamp column on it; however, when I try to query
based on it, it fails saying that I must use ALLOW FILTERING--which to me,
means its not using the secondary index. Table definition is (snipping out
irrelevant parts)...
CREATE TABLE audit (
> id bigint,
>
> But for about 12 hours the secondary index has completed only 3%.
How much data do you have?
> I use Cassandra 1.0.7 and use CL of ONE for my read requests.
There is your problem.
If you use CL ONE for any time type of query you can get inconsistent results.
Hinted Handoff and Read
As stated in topic, I'm unable to drop secondary index either by using
cli or cqlsh. In both cases it looks like to command is processed
properly (some uuid shows up in cli, no output in cqlsh), I can see in
logs that schema is going to be updated (index name and type are set to
null) and
r type has very little to do with the performance.
Hope that helps.
-
-
Aaron Morton
Freelance Cassandra Developer
@aaronmorton
http://www.thelastpickle.com
On 9 Jul 2011, at 12:15, Eldad Yamin wrote:
> Hi,
> I have few questions:
>
> Secondary index
rations have
> to pay a constant cost to decode the row level column index, this can be
> tuned though. AFAIK the comparator type has very little to do with the
> performance.
>
> Hope that helps.
>
> -
> -
> Aaron Morton
> Freelance Cassand
> performance.
>
> Hope that helps.
>
> -
> -
> Aaron Morton
> Freelance Cassandra Developer
> @aaronmorton
> http://www.thelastpickle.com
>
> On 9 Jul 2011, at 12:15, Eldad Yamin wrote:
>
>> Hi,
>> I have few questi
ss of the
>>column’s name is high when comparator is LONG_TYPE/TimeUUID and each row
>> has
>>lots of columns?
>>
>> Depends on what sort of operations you are doing. Some read operations
>> have to pay a constant cost to decode the row level column index,
I'm thinking about Secondary indexes as an alternative for using
column families to index my data.
I'd appreciate some answers to basic questions about this new feature.
1. Can you insert a row to a column family with a predefined column
metadata (and secondary index for these columns)
Hi,
I was wondering if anyone would know if secondary index can be enabled on
composite columns?
Regards
Boris
omized
> secondary index is:
> We use one CF, each row to represent a secondary index, with the secondary
> index name as row key.
> For example,
>
> Indexes = {
> "User_Keys_By_Last_Name" : {
> "adams" : "e5d61f2b-…",
> "alden" : &q
in UW wrote:
>
> > Hello,
> >
> > As mentioned by Ed Anuff in his blog and slides, one way to build
> customized secondary index is:
> > We use one CF, each row to represent a secondary index, with the
> secondary index name as row key.
> > For example,
>
On Tue, Aug 23, 2011 at 10:03 AM, Alvin UW wrote:
> Hello,
>
> As mentioned by Ed Anuff in his blog and slides, one way to build customized
> secondary index is:
> We use one CF, each row to represent a secondary index, with the secondary
> index name as row key.
> For
Yes, this is what I am worrying about.
2011/8/24 Ryan King
> On Tue, Aug 23, 2011 at 10:03 AM, Alvin UW wrote:
> > Hello,
> >
> > As mentioned by Ed Anuff in his blog and slides, one way to build
> customized
> > secondary index is:
> > We use one CF, eac
8/24 Ryan King
>
>> On Tue, Aug 23, 2011 at 10:03 AM, Alvin UW wrote:
>> > Hello,
>> >
>> > As mentioned by Ed Anuff in his blog and slides, one way to build
>> customized
>> > secondary index is:
>> > We use one CF, each row to rep
st 25, 2011 12:48:49 PM
Subject: Re: Customized Secondary Index Schema
How many unique last names do you anticipate having? How many characters in the
last name do you anticipate keeping in your index? You can easily do the math
to figure out how many you could fit on a node. I think you'
mn family
> key as the column name. This will ensure that your index is evenly
> distributed throughout your cluster.
>
> - Original Message -
> From: "Ed Anuff"
> To: user@cassandra.apache.org
> Sent: Thursday, August 25, 2011 12:48:49 PM
> Subject: R
Thanks.
Assume I use this approach, use the last names as the row keys of secondary
index, and use the base column family key as the column name.
There may be duplication key issue. We may solve it by composite key, like
"adams_1" , "adams_2".
Then, we can query these index by
read together. If you are going
to query for all of them at the same time anyways, this disadvantage does not
apply to you.
- Original Message -
From: "Alvin UW"
To: user@cassandra.apache.org
Sent: Thursday, August 25, 2011 5:11:07 PM
Subject: Re: Customized Secondary Index Sche
My guess would be you're querying using a different encoding and there
really is no data for your query as given. Hard to say without more
details.
On Wed, Sep 7, 2011 at 8:13 AM, Thamizh wrote:
>
> Hi All,
>
> I have created KS & CF using cassandra-0.7.8 and inserted some rows and
> column val
sucessfully. Why?
Regards,
Thamizhannal P
--- On Wed, 7/9/11, Jonathan Ellis wrote:
From: Jonathan Ellis
Subject: Re: Secondary index update issue
To: user@cassandra.apache.org
Date: Wednesday, 7 September, 2011, 7:29 PM
My guess would be you're querying using a different encoding and there
5398995980)
>
> What encoding format should I use?. Here I defined ip as LongType & domain as
> utf8.
>
> When I upload data using above mentioned index type on CF definition then,
> above queries are working sucessfully. Why?
>
>
> Regards,
> Thamizhannal P
>
>
Hi,
I am using Casandra 0.7 trunk (r997357) and am having issues with a
secondary index.
I have a ColumnFamily with a secondary index on column "X". Not every row of
data has column X. It looks like when I write a row that does not have
column X, Cassandra throws the following NPE when
secondary index results are always sorted by indexed column value.
rows with the same index value are sorted in token order (although
support for comparator order is planned).
sorting by a different column is not possible to do efficiently
server-side and therefore is left to the client.
On Fri
client.
>
> On Fri, Oct 1, 2010 at 10:13 AM, Petr Odut wrote:
> > Hi,
> > is it possible to sort results based on secondary index search?
> > Typical use case is to get most recent comments from specified group
> > CF: comments
> > * SI: group
> > * SI:
ults are sorted in token order (I should
> expect to be sorted by 1st expression column values).
> Am I correct?
> On Fri, Oct 1, 2010 at 5:18 PM, Jonathan Ellis wrote:
>>
>> secondary index results are always sorted by indexed column value.
>> rows with the same index
Hi Jonathan,
I don't suppose there's any plan to support subcolumns of supercolumns in
secondary indexes in the future ?
Regards
Jason
On Fri, Oct 1, 2010 at 4:18 PM, Jonathan Ellis wrote:
> secondary index results are always sorted by indexed column value.
> rows with the
Thanks for the info. Will be ever possible to going throught a secondary
index (since SI is sorted by default)? My use case is to display newest
comments, users, etc. SI from my point of view perfectly fits here.
Thanks :)
Petr Odut.
Dne 2010 10 1 18:26 "Jonathan Ellis" nap
Yes, but probably not in 0.7.0.
On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut wrote:
> Thanks for the info. Will be ever possible to going throught a secondary
> index (since SI is sorted by default)? My use case is to display newest
> comments, users, etc. SI from my point of view perfe
partly good news, thanks
Petr Odut
On Mon, Oct 4, 2010 at 5:40 PM, Jonathan Ellis wrote:
> Yes, but probably not in 0.7.0.
>
> On Sun, Oct 3, 2010 at 12:08 PM, Petr Odut wrote:
> > Thanks for the info. Will be ever possible to going throught a secondary
> > index (
No.
On Sun, Feb 13, 2011 at 8:48 AM, Shay Assulin wrote:
> HI,
>
> Is there a way to get only the keys of indexed rows (without getting
> columns) using get_indexed_slices method?
>
> I am using Hector to access Cassandra and I want to count rows with a
> specific index - so i need to get only th
Yes, that is a known weakness of the current cli interface to column_metadata.
On Wed, Feb 16, 2011 at 3:16 PM, Yueyu Fu wrote:
> Hi,
>
> I'm trying to add a new secondary index on a CF which already have a
> secondary index by calling "update column family".
>
&
I sidestep this problem by using a Python script (pycassa-based) where I
configure my CFs. This way, it's reproducible and documented.
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/create-additional-secondary-index-tp6033574p6033683.html
https://issues.apache.org/jira/browse/CASSANDRA-2244
On Thu, Mar 10, 2011 at 9:28 PM, Rommel Garcia wrote:
> I tried the tutorial on this site
> - http://www.datastax.com/docs/0.7/data_model/secondary_indexes and worked
> on creating an index on a new column. That went good. But when I indexed an
, Jun 19, 2012 at 12:23 PM, Yuhan Zhang wrote:
> Hi all,
>
> I'm trying to search by the secondary index of cassandra with "greater
> than or equal". but reached an exception stating:
> me.prettyprint.hector.api.exceptions.HInvalidRequestException:
> InvalidReq
t;
>
> On Tue, Jun 19, 2012 at 12:23 PM, Yuhan Zhang wrote:
>>
>> Hi all,
>>
>> I'm trying to search by the secondary index of cassandra with "greater
>> than or equal". but reached an exception stating:
>> me.prettyprint.hector.api.exceptions.HIn
Hi Jonathan, thanks for the reference. will read up on it.
Yuhan
Hi all
We have 4 indexed columns; all configured in UT8Type even if one columns is
a date and the other an integer).
1/ the read query we run can have up to 4 criteria
*select my_cf where columnA = a and columnB = b and columnC = c and columnD
= d*
This query, is fast (<500ms) up to 3 criterias
On Thu, Aug 23, 2012 at 6:54 PM, Richard Crowley wrote:
> I have a three-node cluster running Cassandra 1.0.10. In this cluster
> is a keyspace with RF=3. I *updated* a column family via Astyanax to
> add a column definition with an index on that column. Then I ran a
> backfill to populate the
What does List my_column_family in CLI show on all the nodes?
Perhaps the syntax u're using isn't correct? You should be getting the
same data on all the nodes irrespective of which node's CLI you use.
The replication factor is for redundancy to have copies of the data on
different nodes to help i
If you are still having problems can you post the query and the output from
nodetool cfstats on one of the nodes that fails ?
cfstats will tell us if the secondary index was built.
Cheers
-
Aaron Morton
Freelance Developer
@aaronmorton
http://www.thelastpickle.com
On 25/08
On Mon, Aug 27, 2012 at 12:59 AM, aaron morton wrote:
> If you are still having problems can you post the query and the output from
> nodetool cfstats on one of the nodes that fails ?
driftx got me sorted. It escaped me that a rolling restart was
necessary to build secondary indexes, which was m
request is received, it is written to the base CF and
secondary index to secondary (hidden) CF. If this right, will the secondary
index be written local the node or will it follow RP/OPP to write to nodes.
2. When a coordinator receives a read request with say predicate x=y where
column x is the
Hello
First get some understanding about secondary indexes.
http://www.datastax.com/docs/1.1/ddl/indexes
Thanks.
--
View this message in context:
http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Cassandra-Secondary-Index-implementation-tp7589792p7589906.html
Sent from the
DROP and re-create the index with the new options
On Fri, Mar 4, 2016 at 3:45 PM, Jacques-Henri Berthemet <
jacques-henri.berthe...@genesys.com> wrote:
> Hi,
>
>
>
> I’m using Cassandra 2.2.5 with a custom secondary index. It’s created with
> the below syntax:
>
>
Subject: Re: Updating secondary index options
DROP and re-create the index with the new options
On Fri, Mar 4, 2016 at 3:45 PM, Jacques-Henri Berthemet
mailto:jacques-henri.berthe...@genesys.com>>
wrote:
Hi,
I’m using Cassandra 2.2.5 with a custom secondary index. It’s created with the
below
t; *Sent:* vendredi 4 mars 2016 14:52
> *To:* user@cassandra.apache.org
> *Subject:* Re: Updating secondary index options
>
>
>
> DROP and re-create the index with the new options
>
>
>
> On Fri, Mar 4, 2016 at 3:45 PM, Jacques-Henri Berthemet <
> jacques-henri.berthe...@genes
s-Henri Berthemet*
>>
>>
>>
>> *From:* DuyHai Doan [mailto:doanduy...@gmail.com]
>> *Sent:* vendredi 4 mars 2016 14:52
>> *To:* user@cassandra.apache.org
>> *Subject:* Re: Updating secondary index options
>>
>>
>>
>> DROP and re-create t
that holds index options but it seems I need to restart Cassandra twice to be
able to see the changes.
Regards,
--
Jacques-Henri Berthemet
From: Jack Krupansky [mailto:jack.krupan...@gmail.com]
Sent: vendredi 4 mars 2016 18:40
To: user@cassandra.apache.org
Subject: Re: Updating secondary index o
I have concern over using secondary index on field with low cardinality.
Lets say I have few billion rows and each row can be classified in 1000
category. Lets say we have 50 node cluster.
Now we want to fetch data for a single category using secondary index over
a category. And query is
unsubsribe
Sent from Yahoo Mail on Android
On Tue, 8 Nov, 2016 at 2:11 pm, Oleg Krayushkin wrote:
Hi, could you please clarify: 100k tombstone limit for SE is per CF, cf-node,
original sstable or (very unlikely) partition?
Thanks!--
Oleg Krayushkin
;src1', 'dst1');
The "select from demo;" gives the expected answer of the one inserted row.
But "select from demo where id2=22" gives 70 rows as result (all the same).
Why? I have read
https://www.datastax.com/dev/blog/cassandra-native-secondary-index-deep-dive
but I don't get it...
thanks for answering,
Michael
1 - 100 of 412 matches
Mail list logo