Secondary Index

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

secondary index problem

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

secondary index performance

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

Secondary Index information

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

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 the secondary index filter, will the co-ordinator node send the requests to

RE: Secondary Index

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

Re: Secondary Index

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

Re: Secondary Index

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

Re: Secondary Index

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

RE: Secondary Index

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

Re: Secondary Index

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

Re: Secondary Index

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 .

Re: Secondary Index

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

Re: Secondary Index

>> >> >> 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

Secondary Index Cleanup

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-

Fixing / Rebuilding Secondary Index

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

Re: secondary index problem

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:

Re: secondary index problem

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

Re: secondary index problem

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

Re: secondary index problem

> 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

Re: secondary index problem

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

Re: secondary index performance

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

Re: secondary index performance

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

Re: secondary index performance

> 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

Cassandra Secondary index/Twissandra

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

Customized Secondary Index Schema

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" :

Secondary index update issue

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

Sorting by secondary index

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]

Re: Secondary Index information

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

Re: Secondary Index information

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-

Re: Secondary Index information

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

Re: Secondary Index information

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

Re: Secondary Index information

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

Secondary index - keys only.

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

create additional secondary index

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

Secondary Index not working?

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

cassandra secondary index with

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

Secondary index partially created

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

Re: Secondary Index Question

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

Cassandra Secondary Index implementation

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

RE: Secondary Index Question

: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

Re: Secondary Index Question

> > >-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

Re: Secondary Index Question

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

Re: Secondary Index Question

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

Updating secondary index options

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

Secondary index tombstone limit

Hi, could you please clarify: 100k tombstone limit for SE is per CF, cf-node, original sstable or (very unlikely) partition? Thanks! -- Oleg Krayushkin

secondary index use case

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

Re: Secondary Index Cleanup

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

Re: Secondary Index Cleanup

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

Cannot query secondary index

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, >

Re: Fixing / Rebuilding Secondary Index

> 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

Unable to drop secondary index

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

Re: Cassandra Secondary index/Twissandra

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

Re: Cassandra Secondary index/Twissandra

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

Re: Cassandra Secondary index/Twissandra

> 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

Re: Cassandra Secondary index/Twissandra

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,

Predefined columns for Secondary 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)

Secondary index on composite columns?

Hi, I was wondering if anyone would know if secondary index can be enabled on composite columns? Regards Boris

Re: Customized Secondary Index Schema

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

Re: Customized Secondary Index Schema

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, >

Re: Customized Secondary Index Schema

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

Re: Customized Secondary Index Schema

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

Re: Customized Secondary Index Schema

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

Re: Customized Secondary Index Schema

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'

Re: Customized Secondary Index Schema

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

Re: Customized Secondary Index Schema

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

Re: Customized Secondary Index Schema

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

Re: Secondary index update issue

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

Re: Secondary index update issue

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

Re: Secondary index update issue

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 > >

Secondary Index Null Pointer Error

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

Re: Sorting by secondary index

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

Re: Sorting by secondary index

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:

Re: Sorting by secondary index

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

Re: Sorting by secondary 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

Re: Sorting by secondary index

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

Re: Sorting by secondary index

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

Re: Sorting by secondary index

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 (

Re: Secondary index - keys only.

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

Re: create additional secondary index

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". > &

Re: create additional secondary index

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

Re: Secondary Index not working?

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

Re: cassandra secondary index with

, 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

Re: cassandra secondary index with

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

Re: cassandra secondary index with

Hi Jonathan, thanks for the reference. will read up on it. Yuhan

Secondary Index, performance , data type

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

Re: Secondary index partially created

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

Re: Secondary index partially created

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

Re: Secondary index partially created

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

Re: Secondary index partially created

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

Secondary index read/write explanation

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

Re: Cassandra Secondary Index implementation

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

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...@genesys.com> wrote: > Hi, > > > > I’m using Cassandra 2.2.5 with a custom secondary index. It’s created with > the below syntax: > >

RE: Updating secondary index options

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

Re: Updating secondary index options

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

Re: Updating secondary index options

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

RE: Updating secondary index options

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

Low cardinality secondary index behaviour

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

Re: Secondary index tombstone limit

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

secondary index on static column

;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   2   3   4   5   >