Re: Problems with adding datacenter and schema version disagreement

Bump, are there any solutions to bring my cluster back to schema consistency? I've 6 node cluster with exactly six versions of schema, how to deal with it? regards Aleksander 2014-03-11 14:36 GMT+01:00 olek.stas...@gmail.com : > Didn't help :) > thanks and regards > Aleksander > > 2014-03-11 14:14

select query returns wrong value if use DESC option

Hi. I am using Cassandra 2.0.6 version. There is a case that select query returns wrong value if use DESC option. My test procedure is as follows: -- cqlsh:test> CREATE TABLE mytable (key int, range int, PRIMARY KEY (key, range)); cqlsh:test> INSERT INTO mytable (key, range) VALUE

CQL Select Map using an IN relationship

Hi there, I'm experimenting using cassandra and have run across an error message which I need a little more information on. The use case I'm experimenting with is a series of document updates (documents being an arbitrary map of key value pairs), I would like to find the latest document updates a

Re: CQL Select Map using an IN relationship

it's not clear to me if your "id" column is the KEY or just a regular column with secondary index. queries that have IN on non primary key columns isn't supported yet. not sure if that answers your question. On Thu, Mar 13, 2014 at 7:12 AM, David Savage wrote: > Hi there, > > I'm experimenting

Re: select query returns wrong value if use DESC option

Consider filing a jira. Cql is the standard interface to cassandra everything is heavily tested. On Thursday, March 13, 2014, Katsutoshi Nagaoka wrote: > Hi. > > I am using Cassandra 2.0.6 version. There is a case that select query returns wrong value if use DESC option. My test procedure is as fo

Re: CQL Select Map using an IN relationship

Hi Peter, Thanks for the help, unfortunately I'm not sure that's the problem, the id is the primary key on the documents table and the timestamp is the primary key on the eventlog table Kind regards, Dave On Thursday, 13 March 2014, Peter Lin wrote: > > it's not clear to me if your "id" colu

Re: Opscenter help?

On 3/13/14, 12:14 AM, Jack Krupansky wrote: Please do use Stack Overflow - that is the appropriate forum for OpsCenter support (unless you are a DataStax customer). Use the OpsCenter tag: http://stackoverflow.com/tags/opscenter/info Unfortunately, as a new user, I cannot use the opscenter tag

Re:

Thanks , Edward and David, Your contribution lead me to the conclusion. Unknown to me, the partition key had 1 value. So of course all info was stored on a single node. Having replication factor 3 lead to having 99 % CPU on 3 machines.  Regarding RAM we have so much CPU power that I actualy run

Re: Opscenter help?

You don't need any reputation points to ask a new question with an existing tag - just type "opscenter" in the Tags box under the question. Otherwise, how would any new user ever be able to ask a question and have it tagged?! -- Jack Krupansky -Original Message- From: Drew from Zhroda

Re: CQL Select Map using an IN relationship

I have no problem doing this w 2.0.5 - what version of C* are you using? Or maybe I don't understand your data model... attach 'creates' if you don't mind. ml On Thu, Mar 13, 2014 at 9:24 AM, David Savage wrote: > Hi Peter, > > Thanks for the help, unfortunately I'm not sure that's the problem,

Re: CQL Select Map using an IN relationship

Hmmm that maybe the problem, I'm currently testing with 2.0.2 which got dragged in by the cassandra unit library I'm using for testing [1] I will try to fix my build dependencies and retry, thx. /Dave [1] https://github.com/jsevellec/cassandra-unit On Thu, Mar 13, 2014 at 1:56 PM, Laing, Michae

Re: Opscenter help?

On 3/13/14, 9:49 AM, Jack Krupansky wrote: You don't need any reputation points to ask a new question with an existing tag - just type "opscenter" in the Tags box under the question. Otherwise, how would any new user ever be able to ask a question and have it tagged?! I dunno, I don't use SE o

Re: Opscenter help?

I'm happy to help here as well :) Can you give some more information? Specifically: What exact versions of EL5 and EL6 have you tried? What version of OpsCenter are you using? What file/dependency is rpm/yum saying conflicts with sudo? Also, you can find the OpsCenter documentation here http://w

Re: CQL Select Map using an IN relationship

Nope, upgraded to 2.0.5 and still get the same problem, I actually simplified the problem a little in my first post, there's a composite primary key involved as I need to partition ids into groups So the full CQL statements are: CREATE KEYSPACE test WITH replication = {'class':'SimpleStrategy', '

Re: CQL Select Map using an IN relationship

Create your table like this and it will work: CREATE TABLE test.documents (group text,id bigint,data map,PRIMARY KEY ((group, id))); The extra parens catenate 'group' and 'id' into the partition key - IN will work on the last component of a partition key. ml On Thu, Mar 13, 2014 at 10:40 AM, D

Re: Opscenter help?

I have seen the conflicts with sudo error but that was with 3.X rpm on the amazon ami, i was how ever able to install it from the tar ball. As Nick has pointed out, the versions of OS and Opscenter will help in looking at this. Thanks Rahul On Thu, Mar 13, 2014 at 7:56 PM, Nick Bailey wrote: >

Re: Dead node seen as UP by replacement node

Are you replacing the node with the same token and the same IP? On Thu, Mar 13, 2014 at 4:36 AM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > Some further info: > > I'm not using Vnodes, so I'm using the 1.1 replace node trick of setting > the initial_token in the cassan

Re: CQL Select Map using an IN relationship

Great that works, thx! I probably would have never found that... It now makes me wonder in general when to use PRIMARY KEY (key1, key2) or PRIMARY KEY ((key1, key2)), any examples would be welcome if you have the time. Kind regards, Dave On Thu, Mar 13, 2014 at 2:56 PM, Laing, Michael wrote:

Re: CQL Select Map using an IN relationship

probably a good idea to open a jira ticket to explain this better in the docs. the downside of moving so fast is the docs often fall behind and users have to dig around to figure things out. not everyone wants to read the CQL3 antlr grammar to figure things out. On Thu, Mar 13, 2014 at 11:27 AM,

Re: 750Gb compaction task

M — Sent from Mailbox for iPhone On Thu, Mar 13, 2014 at 1:28 AM, Plotnik, Alexey wrote: > After rebalance and cleanup I have leveled CF (SSTable size = 100MB) and a > compaction Task that is going to process ~750GB: >> root@da1-node1:~# nodetool compactionstats > pending tasks: 10556 >

Re: Dead node seen as UP by replacement node

Nope, they have different IPs. I'm using the procedure described here to replace a dead node: http://www.datastax.com/docs/1.1/cluster_management#replacing-a-dead-node Dead node token: X (IP: Y) Replacement node token: X-1 (IP: Z) So, as soon as the replacement node (Z) is started, it sees the de

Re: Dead node seen as UP by replacement node

And the token value as suggested is tokenvalueoddeadnode-1 ? On Thu, Mar 13, 2014 at 9:29 PM, Paulo Ricardo Motta Gomes < paulo.mo...@chaordicsystems.com> wrote: > Nope, they have different IPs. I'm using the procedure described here to > replace a dead node: > http://www.datastax.com/docs/1.1/c

Re: CQL Select Map using an IN relationship

On Thu, Mar 13, 2014 at 12:12 PM, David Savage wrote: > Hi there, > > I'm experimenting using cassandra and have run across an error message > which I need a little more information on. > > The use case I'm experimenting with is a series of document updates > (documents being an arbitrary map of k

Simulated Disaster Recovery Steps

I'm trying to simulate a DR scenario. I have successfully simulated the 'D', but my 'R' isn't quite right. Quick background: 1.1) Cassandra. 1.2.13. static tokens (no vnodes). Ec2Snitch. Murmur3Partitioner 1.2 For this simulation, 2-node cluster with RF of 1 on AWS EC2 instances 1.3) Simulated dat

Re: Dead node seen as UP by replacement node

Yes, exactly. On Thu, Mar 13, 2014 at 1:27 PM, Rahul Menon wrote: > And the token value as suggested is tokenvalueoddeadnode-1 ? > > > On Thu, Mar 13, 2014 at 9:29 PM, Paulo Ricardo Motta Gomes < > paulo.mo...@chaordicsystems.com> wrote: > >> Nope, they have different IPs. I'm using the procedu

Issue - Creation of Secondary Index on Existing Data results in NO ROWS returned

We have Cassandra Version 1.2.15 and 1.2.9 and we have this issue on both the version. We have a Cassandra Column Family with 3000 rows. We created a secondary Index on the table. When we try to select the data for existing rows using the Secondary Key, it returns no rows, even though we see the

Re: CQL Select Map using an IN relationship

Think of them as: PRIMARY KEY (partition_key[, range_key]) where the partition_key can be compounded as: (partition_key0 [, partition_key1, ...]) and the optional range_key can be compounded as: range_key0 [, range_key1 ...] If you do this: PRIMARY KEY (key1, key2) - then key1 is the partitio

Re: 750Gb compaction task

On Wed, Mar 12, 2014 at 10:27 PM, Plotnik, Alexey wrote: > I have no space for this operation, I have 300 Gb only. Is it possible to > resolve this situation? > > compactionstats shows non-compressed size. As long as you have compression enabled, which is the default, you should be fine. =Rob

Re: Problems with adding datacenter and schema version disagreement

On Thu, Mar 13, 2014 at 2:05 AM, olek.stas...@gmail.com < olek.stas...@gmail.com> wrote: > Bump, are there any solutions to bring my cluster back to schema > consistency? > I've 6 node cluster with exactly six versions of schema, how to deal with > it? > The simplest way, which is most likely to

Re: CQL Select Map using an IN relationship

“range key” is formally known as “clustering column”. One or more clustering columns can be specified to identify individual rows in a partition. Without clustering columns, one partition is one row. So, it’s a matter of whether you want your rows to be in the same partition or distributed. --

Re: CQL Select Map using an IN relationship

I have found that range_key communicates better what you can actually do with them, whereas clustering is more passive. ml On Thu, Mar 13, 2014 at 2:08 PM, Jack Krupansky wrote: > “range key” is formally known as “clustering column”. One or more > clustering columns can be specified to identi

Re: Issue - Creation of Secondary Index on Existing Data results in NO ROWS returned

I did some quick testing to try and reproduce the issue you are seeing (using 1.2.15). I wasn't able to get the same issue to happen though. You are correct that normally the pre-existing values would be indexed and searchable. You may want to search JIRA to see if anyone else has had the issue, an

Re: CQL Select Map using an IN relationship

Thanks for the explanations. To confirm I understand, Michaels explanation seems to say that that : * the partition key supports =/IN but not >,>=,<,<= * the range key (or clustering column) supports =,>,>=,<,<= but not IN. Is that correct? Jacks explanation seems to say that by grouping the two

Re: Problems with adding datacenter and schema version disagreement

Huh, you mean json dump? Regards Aleksander 2014-03-13 18:59 GMT+01:00 Robert Coli : > On Thu, Mar 13, 2014 at 2:05 AM, olek.stas...@gmail.com > wrote: >> >> Bump, are there any solutions to bring my cluster back to schema >> consistency? >> I've 6 node cluster with exactly six versions of schema

Need help understanding hinted_handoff_throttle_in_kb

I came across something on the cassandra it that made me concerned. Default value for hinted_handoff_throttle_in_kb is 1024, one Meg per second. I have four nodes and rf=2. I have hints timeout set to 24, to avoid having to do repairs if I took longer than that to reboot a node. What got me think

Re: Problems with adding datacenter and schema version disagreement

On Thu, Mar 13, 2014 at 1:20 PM, olek.stas...@gmail.com < olek.stas...@gmail.com> wrote: > Huh, > you mean json dump? > If you're using cassandra-cli, I mean the output of "show schema;" If you're using CQLsh, there is an analogous way to show all schema. 1) dump schema to a file via one of the

1.2: Why can't I see what is in "hints" CF ?

Check this out: [default@system] list hints limit 10; Using default cell limit of 100 null TimedOutException() at org.apache.cassandra.thrift.Cassandra$get_range_slices_result.read(Cassandra.java:12932) at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:78) at org.

Re: How to guarantee consistency between counter and materialized view?

Robert Coli wrote: > On Tue, Mar 11, 2014 at 4:30 PM, ziju feng wrote: > > Is there any way to guarantee a counter's value > > no. > > =Rob I wouldn't use cassandra for counters... Use something like redis if that is what you want.

Re: CQL Select Map using an IN relationship

These are my personal opinions, reflecting both my long experience w database systems, and my newness to Cassandra... [tl;dr] The Cassandra contributors, having made its history, tend to describe it in terms of implementation rather than action. And its implementation has a history, all relativel