Re: UnavailableException with 1 node down and RF=2?

Thats correct. It was a read consistency problem, not so smart of me ;-) Thank you anyway. 2011/10/27 Jonathan Ellis > (I see that you did start a new thread and solved it with Jake's help.) > > On Thu, Oct 27, 2011 at 11:23 AM, Jonathan Ellis > wrote: > > Ha. On the one hand, good on you for

Re: Doubts related to composite type column names/values

Is it true that you can also just get the same results as when you pick a UTF8 key with this content: keyA:keyB Of should you really use the composite keys? If so, what is the big advantage of composite over combined utf-8 keys? Robin 2011/12/21 Sylvain Lebresne > On Tue, Dec 20, 2011 at 9:33

Re: Counters and Top 10

I would suggest you to create a CF with a single row (or multiple for historical data) with a date as key (utf8, e.g. 2011-12-22) and multiple columns for every user's score. The column (utf8) would then be the score + something unique of the user (e.g. hex representation of the TimeUUID). The valu

Re: Suggestion about syntax of CREATE COLUMN FAMILY

As a starter I also fully agree with this suggestion. You could submit it as feature request to the Cassandra JIRA. 2011/12/12 Stephen Pope > I’d like to second this. I’ve been working with Cassandra for a good > while now, but when I first started little things like this were confusing. >

Re: Newbie question about writer/reader consistency

You might consider a hybrid solution with a transactional db for all data that should be ACID complient and Cassandra for the huge amounts of data you want to store. 2011/12/27 Radim Kolar > > makes me feel disappointed about consistency in Cassandra, but I wonder is >> there is a way to work a

Re: Row or Supercolumn with approximately n columns

@Aaron: Small side question, when do columns with a past TTL get removed? On a repair, (minor) compaction, or .. ? Does it have a performance drop if that's happening? 2012/1/2 aaron morton > Even if you had compaction enforcing a limit on the number of columns in a > row, there would still be i

Writes slower then reads

Hi there, I'm running a cassandra 0.8.6 cluster with 2 nodes (in 2 DC's), RF = 2. Actual data on the nodes is only 1GB. Disk latency < 1ms. Disk throughput ~ 0.4MB/s. OS load always below 1 (on a 8 core machine with 16GB ram). When I'm running my writes against the cluster with cl = ONE all reads

Re: Writes slower then reads

CPU is idle (< 10% usage). Disk reads occasionally blocks over 32/64K. Writes around 0-5MB per second. Network traffic 0.1 / 0.1 MB/s (in / out). Paging 0. System int ~ 1300, csw ~ 2500. 2012/1/5 Philippe > What can you see in vmstat/dstat ? > Le 5 janv. 2012 11:58, "R. Verla

Re: Writes slower then reads

As I posted this I noticed that the other node's CPU is running high on some other cronjobs (every couple of minutes to 60% usage). Is the lack of more CPU cycles a problem in this case? Robin 2012/1/5 R. Verlangen > CPU is idle (< 10% usage). Disk reads occasionally blocks

Re: Writes slower then reads

s > your read CL ? > > 2012/1/5 R. Verlangen > > As I posted this I noticed that the other node's CPU is running high on >> some other cronjobs (every couple of minutes to 60% usage). Is the lack of >> more CPU cycles a problem in this case? >> >> Robin

Re: Writes slower then reads

t; can't act as a coordinator fast enough. > > 2012/1/5 R. Verlangen > > I'm also reading with CL = ONE >> >> >> 2012/1/5 Philippe >> >>> Depending on the CL you're reading at it will yes : if the CL requires >>> that the "s

Re: Writes slower then reads

ement in response > time which would validate my hypothesis. > > > 2012/1/5 R. Verlangen > > It does not appear to affect the response time, certainly not in a >> positive way. >> >> >> 2012/1/5 Philippe >> >>> What if you shutdown the cas

Re: Writes slower then reads

... don't have any other idea for > now... > > 2012/1/5 R. Verlangen > >> The write and read load is very minimal the moment. Roughly 10 writes + >> 10 reads / second. So 20 operations per second. Don't think that overloads >> my cluster, does it? >> &g

Re: java.lang.IllegalArgumentException occurred when creating a keyspcace with replication factor

Try this: create keyspace testkeyspace; update keyspace testkeyspace with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' and strategy_options = {replication_factor:3}; Good luck! 2012/1/6 Sajith Kariyawasam > Hi all, > > I tried creating a keyspace with the replication fact

Re: How to find out when a nodetool operation has ended?

You might consider: - installing DataStax OpsCenter ( http://www.datastax.com/products/opscenter ) - starting the repair in a linux screen (so you can attach to the screen from another location) I prefer the OpsCener. 2012/1/6 Maxim Potekhin > Suppose I start a repair on one or a few nodes in

Re: What is the future of supercolumns ?

My suggestion is simple: don't use any deprecated stuff out there. In practically any case there is a good reason why it's deprecated. I've seen a couple of composite-column vs supercolumn discussions in the past weeks here: I think a little bit of searching will get you around. Cheers 2012/1/7

Re: How to find out when a nodetool operation has ended?

hin wrote: > > Thanks, so I take it there is no solution outside of Opcenter. > > I mean of course I can redirect the output, with additional timestamps if > needed, > to a log file -- which I can access remotely. I just thought there would > be some "status" > command

Re: Re: Schema clone ...

A "null" response is most of the times an exception, try to take a look at the Cassandra logs to find out what causes the problem. 2012/1/9 cbert...@libero.it > I was just trying it but ... in 0.7 CLI there is no show schema command. > > When I connect with 1.0 CLI to my 0.7 cluster ... > > > [d

Re: nodetool ring question

I also have this problem. My data on nodes grows to roughly 30GB. After a restart only 5GB remains. Is a factor 6 common for Cassandra? 2012/1/18 aaron morton > Good idea Jeremiah, are you using compression Michael ? > > Scanning through the CF stats this jumps out… > > Column Fa

Re: nodetool ring question

p://www.thelastpickle.com > > On 18/01/2012, at 10:58 PM, Michael Vaknine wrote: > > I did restart the cluster and now it is normal 5GB. > ** ** > *From:* R. Verlangen [mailto:ro...@us2.nl] > *Sent:* Wednesday, January 18, 2012 11:32 AM > *To:* user@cassandra.apache.org

Re: Data Model Question

A couple of days ago I came across Countandra ( http://countandra.org/ ). It seems that it might be a solution for you. Gr. Robin 2012/1/20 Tamar Fraenkel > ** > > Hi! > > I am a newbie to Cassandra and seeking some advice regarding the data > model I should use to best address my needs. > >

Re: Tips for using OrderedPartitioner

If you would like to index your rows in an "index-row", you could also choose for indexing the "index-rows". This will scale up for any needs and create a tree structure. 2012/1/24 aaron morton > Nothing I can thin of other than making the keys uniform. > > Having a single index row with the RP

Re: Enable thrift logging

Pick a "custom" loglevel and redirect them with the /etc/syslog.conf ? 2012/1/24 ruslan usifov > Hello > > I try to log thrift log message (this need to us for solve communicate > problem between Cassandra daemon and php client ), so in > log4j-server.properties i write follow lines: > > log4j.l

Restart cassandra every X days?

Hi there, I'm currently running a 2-node cluster for some small projects that might need to scale-up in the future: that's why we chose Cassandra. The actual problem is that one of the node's harddrive usage keeps growing. For example: - after a fresh restart ~ 10GB - after a couple of days runni

Re: Restart cassandra every X days?

Ok thank you for your feedback. I'll add these tasks to our daily cassandra maintenance cronjob. Hopefully this will keep things under controll. 2012/1/25 Karl Hiramoto > On 01/25/12 16:09, R. Verlangen wrote: > >> Hi there, >> >> I'm currently running a 2-no

Re: Restart cassandra every X days?

Thanks for reminding. I'm going to start with adding the cleanup & compact to the chain of maintenance tasks. In my opinion java should determine itselfs when to start a GC: doesn't feel natural to do this manually. 2012/1/25 Karl Hiramoto > > On 01/25/12 19:18, R. Verl

Re: Restart cassandra every X days?

ssandra.apache.org > Subject: Re: Restart cassandra every X days? > > > On 01/25/12 19:18, R. Verlangen wrote: > > Ok thank you for your feedback. I'll add these tasks to our daily > > cassandra maintenance cronjob. Hopefully this will keep things under > > c

Re: Restart cassandra every X days?

andra process. You will > lose all the run time optimizations the JVM has made (i think the mapped > files pages will stay resident). As well as adding additional entropy to > the system which must be repaired via HH, RR or nodetool repair. > > If you want to see compacted files p

Re: How to create a table in Cassandra

A "table" is called a "column family" in Cassandra. >From the CLI you can just create one by typing: create column family MyApplication; -- Forwarded message -- > From: > Date: Fri, Jan 27, 2012 at 2:36 PM > Subject: How to create a table in Cassandra > To: d...@cassandra.apac

Re: Restart cassandra every X days?

Ok, seems that it's clear what I should do next ;-) 2012/1/28 aaron morton > There are no blockers to upgrading to 1.0.X. > > A > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 28/01/2012, at 7:48 AM

Re: Any tools like phpMyAdmin to see data stored in Cassandra ?

You might run it from a VM? 2012/1/30 Ertio Lew > > > On Mon, Jan 30, 2012 at 7:16 AM, Frisch, Michael < > michael.fri...@nuance.com> wrote: > >> OpsCenter? >> >> http://www.datastax.com/products/opscenter >> >> - Mike >> >> >> I have tried Sebastien's phpmyAdmin For >> Cassandra

Re: Restart cassandra every X days?

ww.thelastpickle.com > > On 29/01/2012, at 4:14 AM, Maxim Potekhin wrote: > > Sorry if this has been covered, I was concentrating solely on 0.8x -- > can I just d/l 1.0.x and continue using same data on same cluster? > > Maxim > > > On 1/28/2012 7:53 AM, R. Verlangen wr

Re: Restart cassandra every X days?

hen > 2) nodetool cleanup if you have changed the tokens at any point finally > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 31/01/2012, at 11:56 PM, R. Verlangen wrote: > > After running

Re: Restart cassandra every X days?

-- > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 2/02/2012, at 9:55 PM, R. Verlangen wrote: > > Yes, I already did a repair and cleanup. Currently my ring looks like this: > > Address DC RackSt

Re: Can you query Cassandra while it's doing major compaction

It will have a performance penalty, so it would be better to spread the compactions over a period of time. But Cassandra will still take care of any reads/writes (within the given timeout). 2012/2/3 myreasoner > If every node in the cluster is running major compaction, would it be able > to > an

Re: yet a couple more questions on composite columns

I also made something like this a while ago. I decided to go for the 2-rows-solution: by doing that you don't have the need for super columns. Cassandra is really good at reading, so this should not be an issue. Cheers! 2012/2/4 Yiming Sun > Thanks Andrey and Chris. It sounds like we don't nec

Re: yet a couple more questions on composite columns

I just kept both row keys the same. This was very trivial for fetching them both. When you have A, you can fetch B, and vice versa. 2012/2/4 Yiming Sun > Interesting idea, R.V. But what did you do with the row keys? > > > On Sat, Feb 4, 2012 at 2:29 PM, R. Verlangen wrote: >

Re: yet a couple more questions on composite columns

Yiming, I am using 2 CF's. Performance wise this should not be an issue. I use it for small files data store. My 2 CF's are: FilesMeta FilesData 2012/2/5 Yiming Sun > Interesting idea, Jim. Is there a reason you don't you use > "metadata:{accountId}" instead? For performance reasons? > > > On

Re: Best way to know the cluster status

You might consider writing some kind of php script that runs nodetool "ring" and parse the output? 2012/2/6 Tamil selvan R.S > Hi, > What is the best way to know the cluster status via php? > Currently we are trying to connect to individual cassandra instance with > a specified timeout and if

Re: nodetool hangs and didn't print anything with firewall

Do you allow both outbound as inbound traffic? You might also try allowing both TCP as UDP. 2012/2/6 Roshan > Yes, If the firewall is disable it works. > > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/nodetool-hangs-and-didn-t-print-anythi

Re: Need database to log and retrieve sensor data

As far as I'm familiar with Cassandra, I gave my opinion for every requirement on your list: 1) 10k inserts / seconds should be no problem at all for Cassandra 2) Cassandra should scale to that 3) As the homepage of Cassandra states that amount of data should be able to fit (source: http://cassan

Re: keycache persisted to disk ?

This is because of the "warm up" of Cassandra as it starts. On a start it will start fetching the rows that were cached: this will have to be loaded from the disk, as there is nothing in the cache yet. You can read more about this at http://wiki.apache.org/cassandra/LargeDataSetConsiderations 201

Re: keycache persisted to disk ?

I also noticed that, Cassandra appears to perform better under a continues load. Are you sure the rows you're quering are actually in the cache? 2012/2/13 Franc Carter > 2012/2/13 R. Verlangen > >> This is because of the "warm up" of Cassandra as it starts.

Re: Deleting a column vs setting it's value to empty

<< Setting to "" may cause you less headaches as you won't have to deal with tombstones >> You won't have to deal with tombstones manually, the Thrift API will take care of this. Deleting an empty column value will always be better; with one exception, when "empty" does actually mean something e

Re: Querying for rows without a particular column

One option might be to maintain an index containing the keys of the rows. The index would then have the same TTL as the row itself so when you iterate over the index columns you'll find exactly the same results. Although I'm not really sure whether this is the best option. Another might be to use

Re: deleting rows and tombstones

Are you planning to insert rows with keys that existed before? If that's true, there will be no tombstones (as far as I understand Cassandra). It that's not, then you will get tombstones that might slow down the reads because they have to be skipped until the next compaction. 2012/2/14 Todd Burr

Re: timed-out retrieving a giant row.

I'm familiar to this in PHPCassa, but with Hector it would be something like this: Query you CF with a range.setStart(lastColName) and range.setFinish(StringUtils.byte("") where the " lastColName " is the name of the column from the previous read. You can continue this until you run out of result

Re: timed-out retrieving a giant row.

Of course you should set your limit to 100 or something like that, not Integer.MAX_VALUE ;-) 2012/2/14 R. Verlangen > I'm familiar to this in PHPCassa, but with Hector it would be something > like this: > > Query you CF with a range.setStart(lastColName) and > range.setFin

Re: CQL query issue when fetching data from Cassandra

I'm not sure about your first 2 questions. The third might be an exception: check your Cassandra logs. About the "like"-thing: there's no such query possibiliy in Cassandra / CQL. You can take a look at Hadoop / Hive to tackle those problems. 2012/2/16 Roshan > Hi > > I am using Cassandra 1.0.

Re: Wide row column slicing - row size shard limit

Things you should know: - Thrift has a limit on the amount of data it will accept / send, you can configure this in Cassandra: 64MB's should still work find (1) - Rows should not become huge: this will make "perfect" load balancing impossible in your cluster - A single row should fit on a disk - T

Replication factor per column family

Hi there, As the subject states: "Is it possible to set a replication factor per column family?" Could not find anything of recent releases. I'm running Cassandra 1.0.7 and I think it should be possible on a per CF basis instead of the whole keyspace. With kind regards, Robin

Re: Replication factor per column family

er reasons as well. In short it's baked in. > > Cheers > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 16/02/2012, at 9:54 PM, R. Verlangen wrote: > > Hi there, > > As the subject states: "I

Re: Replication factor per column family

Ok, that's clear, thank you for your time! 2012/2/16 aaron morton > yes. > > - > Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 16/02/2012, at 10:15 PM, R. Verlangen wrote: > > Hmm ok. This means

Re: Newbie Question: Cassandra consuming 100% CPU on ubuntu server

You might want to check your Cassandra logs, they contain important information that might lead you to the actual cause of the problems. 2012/2/18 Aditya Gupta > Thanks! But what about the 100% cpu consumption that is causing the server > to hang? > > > On Sat, Feb 18, 2012 at 6:19 PM, Watanabe

Re: List all keys with RandomPartitioner

You can leave the end key empty. 1) Start with "startkey" = "" 2) Next iteration start with "startkey" = "last key of the previous batch" 3) Keep on going until you ran out of results 2012/2/22 Rafael Almeida > > > > From: Franc Carter > >To: user@cassandra.apac

Re: Please advise -- 750MB object possible?

I would suggest you chunk them down into small pieces (~ 10-50MB) and just fetch all the parts you need. A problem might be that if fetching one fails, the whole blob is useless. 2012/2/22 Rafael Almeida > Keep them where? > > -- > *From:* Mohit Anchlia > *To:* use

Combining Cassandra with some SQL language

Hi there, I'm currently busy with the technical design of a new project. Of course it will depend on your needs, but is it weird to combine Cassandra with a SQL language like MySQL? In my usecase it would be nice because we have some tables/CF's with lots and lots of data that does not really hav

Re: Combining Cassandra with some SQL language

; you're planning on creating a data model that spans multiple databases make > sure you encapsulate the logic to read/write/delete information in a good > data model library and only use that library to access your data. This is > good practice anyway but when you add the ext

Re: TimeUUID

For querying purposes it would be better to use readable strings because you can really get information out of that. TimeUUID is just a unique value based on time; but not only the time. 2012/2/28 Tamar Fraenkel > Hi! > I have a column family where I use rows as "time buckets". > What I do is t

Node joining / unknown

Hi there, I'm currently in a really weird situation. - Nodetool ring says node X is joining (this already takes 12 hours, with no activity) - When I try to remove the token, it says: Exception in thread "main" java.lang.UnsupportedOperationException: Token not found. - Removetoken status = No toke

Re: Node joining / unknown

> Aaron Morton > Freelance Developer > @aaronmorton > http://www.thelastpickle.com > > On 7/03/2012, at 9:11 PM, R. Verlangen wrote: > > Hi there, > > I'm currently in a really weird situation. > - Nodetool ring says node X is joining

Re: Node joining / unknown

@Brandon: Thank you for the information. I'll do that next time. @Igor: Any ways to find out whether that is the current state? And if so, how to solve it? 2012/3/7 > Maybe it wait for verification compaction on other node? > > > > > > -Original Message- &g

Re: Node joining / unknown

e current state? And if so, > how to solve it? > > 2012/3/7 > >> Maybe it wait for verification compaction on other node? >> >> >> >> >> >> -Original Message- >> From: "R. Verlangen" >> To: user@cassandra.apache.o

Re: Single Node Cassandra Installation

Hi Drew, One other disadvantage is the lack of "consistency level" and "replication". Both ware part of the high availability / redundancy. So you would really need to backup your single-node-"cluster" to some other external location. Good luck! 2012/3/15 Drew Kutcharian > Hi, > > We are worki

Re: Single Node Cassandra Installation

aybe even used off >>> ebay??) so I could have at least two of them. >>> >>> If you do go with a one node solution, altho I haven't tried it myself >>> Priam looks like a good place to start for backups, otherwise roll your own >>> with inc

Re: 0.8.1 Vs 1.0.7

Check your log for messages about rebuilding indices: that might grow your dataset some. One thing is for sure: the data import removed all the crap that lasted in the 0.8.1 cluster (duplicates, thombstones etc). The decrease is fairly dramatic but not unlogical at all. 2012/3/16 Jeremiah Jordan

Re: cassandra-cli and "uncreachable" status confusion

That's correct. If you run describe cluster normally you'll see something like: Cluster Information: Snitch: org.apache.cassandra.locator.SimpleSnitch Partitioner: org.apache.cassandra.dht.RandomPartitioner Schema versions: 3a0f6a80-7140-11e1--511aec3785ff: [IP_OF_NODE, IP_OF

Re: Error in FAQ?

If you want to modify a column family, just open the command line interface (cassandra-cli), connect to a node (probably: "connect localhost/9160;"). When you have to create your first keyspace type: "create keyspace MyKeyspace;" For modifying an existing keyspace type: "use MyKeyspace;" If you

Re: Fwd: information on cassandra

Yes, you can add nodes to a running "cluster". It's very simple: configure the cluster name and seed node(s) in cassandra.yaml, set auto_bootstrap to true and start the node. 2012/3/26 puneet loya > 5n.. consider i m starting on a single node. can I add nodes later?? plz > reply :) > > > On Sun,

Re: problem in create column family

You should use the full type names, e.g. create column family MyColumnFamily with comparator=UTF8Type; 2012/3/26 puneet loya > It is giving errors like " Unable to find abstract-type class > 'org.apache.cassandra.db.marshal.utf8' " > > and java.lang.RuntimeException: > org.apache.cassandra.db.m

Re: How to store a list of values?

In this case you only neem the columns for values. You don't need the column-values to hold multiple columns (the super-column principle). So a normal CF would work. 2012/3/26 Ben McCann > Thanks for the reply Samal. I did not realize that you could store a > column with null value. Do you kno

Re: How to store a list of values?

null, > 'cobol': null > } > > However, I'm still not sure yet how to accomplish this with Astyanax. > I've only figured out how to make composite columns with predefined column > names with it and not dynamic column names like this. > > > > On Mon,

Re: How to store a list of values?

ething along the lines of adding a skills super column to the User table: >>> >>> skills: { >>> 'java': null, >>> 'c++': null, >>> 'cobol': null >>> } >>> >>> However, I'm still not

Re: Performance overhead when using start and end columns

@Aaron: Very interesting article! Mentioned it on my Dutch blog. 2012/3/26 Mohit Anchlia > Thanks! > > > On Mon, Mar 26, 2012 at 10:53 AM, aaron morton wrote: > >> See the test's in the article. >> >> The code I used for profiling is also available. >> >> Cheers >> >>- >> Aar

Re: cassandra 1.08 on java7 and win7

Ben Coverston wrote earlier today: " Use a version of the Java 6 runtime, Cassandra hasn't been tested at all with the Java 7 runtime" So I think that might be a good way to start. 2012/3/26 Frank Hsueh > I think I have cassandra the server started > > In another window: > > > cassandra-cl

Re: problem in create column family

; so can i use comparator='utf8' or not?? > > > Please reply > > > On Mon, Mar 26, 2012 at 9:17 PM, R. Verlangen wrote: > >> You should use the full type names, e.g. >> >> create column family MyColumnFamily with comparator=UTF8Type; >> >&g

Re: unbalanced ring

Cassandra is built to store tons and tons of data. In my opinion roughly ~ 6MB per node is not enough data to allow it to become a fully balanced cluster. 2012/3/27 Tamar Fraenkel > This morning I have > nodetool ring -h localhost > Address DC RackStatus State Load >

Re: How to store a list of values?

That's true, but it does not sound like a real problem to me.. Maybe someone else can shed some light upon this. 2012/3/27 samal > > > On Tue, Mar 27, 2012 at 1:47 AM, R. Verlangen wrote: > >> " but any schema change will break it " >> >> How do yo

Re: Fwd: information on cassandra

Thank you Maki, wasn't aware of that. 2012/3/27 Maki Watanabe > auto_bootstrap has been removed from cassandra.yaml and always enabled > since 1.0. > fyi. > > maki > > 2012/3/26 R. Verlangen : > > Yes, you can add nodes to a running "cluster". It'

Re: Schema advice/help

You can just get a slice range with as start "userId:" and no end. 2012/3/27 Maciej Miklas > multiget would require Order Preserving Partitioner, and this can lead to > unbalanced ring and hot spots. > > Maybe you can use secondary index on "itemtype" - is must have small > cardinality: > http:/

Re: counter column family

*create column family MyCounterColumnFamily with default_validation_class=CounterColumnType and key_validation_class=UTF8Type and comparator=UTF8Type;* There you go! Keys must be utf8, as well as the column names. Of course you can change those validators. Cheers! 2012/3/27 puneet loya > Can u

Re: counter column family

7;auto increment' in other > databases rite? > > > > I mean we have a column of type integer which increments with every > insert. > > > > Am i goin the rite way?? > > > > please reply :) > > On Tue, Mar 27, 2012 at 5:50 PM, R. Verlangen wrote: &g

Re: import

You can write your own script to parse the excel file (export as csv) and import it with batch inserts. Should be pretty easy if you have experience with those techniques. 2012/3/27 puneet loya > I want to import files from excel to cassandra? Is it possible?? > > Any tool that can help?? > > W

Re: Graveyard compactions, when do they occur?

Cassandra "graveyard" sounds like a lot of thombstones that will be compacted during normal compact. You can trigger that manually using the nodetool. 2012/3/28 Erik Forsberg > Hi! > > I was trying out the "truncate" command in cassandra-cli. > > http://wiki.apache.org/**cassandra/CassandraCli0

Re: How to store a list of values?

'software engineer', > 'company': 'google', > 'location': 'orange county', > 'skill:java': '', > 'skill:html': '', > 'skill:javascript': '' > } > > > O

Re: How to store a list of values?

t; > > On Wed, Mar 28, 2012 at 12:34 AM, R. Verlangen wrote: > >> Yes, that is one of the possible solutions to your problem. >> >> When you want to retrieve only the skills of a particular row just get >> the columns with as start value "skill:". >>

Re: opscenter

As far as I'm aware of that is not possible using the opscenter. I recommend you use the cassandra-cli and perform an update column family query. 2012/3/29 puneet loya > I m currently using the the datastax opscenter. > > How do we add column to the column families in opscenter?? > > > -- Wi

Re: Any improvements in Cassandra JDBC driver ?

The best would to not use update / insert at all but "set" / "put" / "save". Cheers! 2012/3/29 Dinusha Dilrukshi > What I want to tell was this driver does not use INSERT key word. Since > CQL support for using INSERT keyword and it is more generic key word used > to add new records, it's more

Re: another DataStax OpsCenter question

Nick, would that also result in useless duplicates of the statistics? 2012/3/30 Nick Bailey > Unfortunately at the moment OpsCenter only really supports having one > instance per cluster. It may be possible to set up an instance in each > datacenter, however it has not been tested and each opsce

Nodetool snapshot, consistency and replication

Hi there, I have a question about the nodetool snapshot. Situation: - 3 node cluster - RF = 3 - fully consistent (not measured, but let's say it is) Is it true that when I take a snaphot at only one of the 3 nodes this contains all the data in the cluster (at least 1 replica)? With kind regards

Re: Nodetool snapshot, consistency and replication

Ok, thank you. 2012/4/2 Rob Coli > On Mon, Apr 2, 2012 at 9:19 AM, R. Verlangen wrote: > > - 3 node cluster > > - RF = 3 > > - fully consistent (not measured, but let's say it is) > > > > Is it true that when I take a snaphot at only one of the 3 nodes

Re: need of regular nodetool repair

Yes, I personally have configured it to perform a repair once a week, as the GCGraceSeconds is at 10 days. This is also what's in the manual http://wiki.apache.org/cassandra/Operations#Repairing_missing_or_inconsistent_data (point 2) 2012/4/11 ruslan usifov > Hello > > I have follow question, i

Re: need of regular nodetool repair

> all HH works, and you never delete your data. > > > On 04/11/2012 11:34 AM, ruslan usifov wrote: > > Sorry fo my bad english, so QUORUM allow doesn't make repair regularity? > But form your anser it does not follow > > 2012/4/11 R. Verlangen > >> Yes, I

Re: cassandra 0.8.7 + hector 0.8.3: All Quorum reads result in writes?

Are you sure this isn't read-repair? http://wiki.apache.org/cassandra/ReadRepair 2012/4/11 Thibaut Britz > Also executing the same multiget rangeslice query over the same range > again will trigger the same writes again and again. > > On Wed, Apr 11, 2012 at 5:41 PM, Thibaut Britz < > thibaut.br

Re: Trouble with wrong data

It sounds like the commitlog has been replayed however I have really no idea whether this could have happened. Anyone? 2012/4/13 Alain RODRIGUEZ > The commitlog_total_space_in_mb was not set, I set it to avoid having the > same problem in the future. > > I am aware of the over-counting problem i

Re: swap grows

Its recommended to disable swap entirely when you run Cassandra on a server. 2012/4/14 ruslan usifov > I forgot to say that system have 24GB of phis memory > > > 2012/4/14 ruslan usifov > >> Hello >> >> We have 6 node cluster (cassandra 0.8.10). On one node i increase java >> heap size to 6GB,

Re: swap grows

here > still about 3GB (on node with JAVA_HEAP=6GB free memory also 3GB) of free > memory but there JAVA_HEAP=5G, so this looks like some sysctl > (/proc/sys/vm???) ratio (about 10%(3 / 24 * 100)), i don't known which, > anybody can explain this situation > > 2012/4/14 R.

Re: blob fields, bynary or hexa?

PHPCassa does support binaries, so that should not be the problem. 2012/4/19 phuduc nguyen > Well, I'm not sure exactly how you're passing a blob to the CLI. It would > be > helpful if you pasted your commands/code and maybe there is a simple > oversight. > > With that said, Cassandra can most d

Re: Bad Request: No indexed columns present in by-columns clause with "equals" operator

I read a while ago that a "compaction" would rebuild the index. You can trigger this by running "repair" with the nodetool. 2012/4/24 > De : mdione@orange.com [mailto:mdione@orange.com] > > [default@avatars] describe HBX_FILE; > > ColumnFamily: HBX_FILE > > Key Validation Class

Use-case: multi-instance webshop

Hi there, I'm working on a datamodel for a multi-website, multi-customer system. Things we would like to do: - search products (lucene / solr / solandra) - multi-filter (e.g. categories) - reviews - voting I can't really see how to do the filtering of the products by categories and even things li

  1   2   >