Graveyard compactions, when do they occur?

Hi! I was trying out the "truncate" command in cassandra-cli. http://wiki.apache.org/cassandra/CassandraCli08 says "A snapshot of the data is created, which is deleted asyncronously during a 'graveyard' compaction." When do "graveyard" compactions happen? Do I have to trigger them somehow?

Re: cqlsh

If you are running on windows the msi installer for datastax community edition will install everything you need and add appropriate entries to your start menu for running the cql shell or the normal cli shell. You can get the installer here: http://www.datastax.com/download/community That might m

Re: cqlsh

cqlsh is a python script. You need python, and cql driver for python. maki 2012/3/28 puneet loya : > i know cqlsh is in the bin directory .. how to run it on Windows? it is not > a batch file that can be run directly? > > Should we use python to execute it?? > > plz show a way :) > > Reply > > >

Re: cqlsh

i know cqlsh is in the bin directory .. how to run it on Windows? it is not a batch file that can be run directly? Should we use python to execute it?? plz show a way :) Reply On Wed, Mar 28, 2012 at 8:34 AM, Maki Watanabe wrote: > You can find it in the bin directory of the binary distributio

Re: cqlsh

You can find it in the bin directory of the binary distribution. maki 2012/3/27 puneet loya : > How do i use the cqlsh comand line utility?? > > I m using cassandra 1.0.8.. Does cqlsh command line utility comes with the > download of cassandra 1.0.8 or we have to do it separately. > > Suggest a

Re: tombstones problem with 1.0.8

(Radim: I'm assuming you mean "do not delete already deleted columns" as Ross doesn't delete his rows.) Just to be clear about Ross' situation: he continually inserts columns and later deletes columns from the same set of rows. As long as he *doesn't* *keep deleting already-deleted columns* (wh

Re: copy data for dev

If you have the disck space you can just copy all the data files from the snapshot onto the dev node, renaming any with conflicting names. Then bring up the dev node and it should see the data. you can then compact to merge and drop all the duplicate data. You can also use the sstable loader

Pushing through major compaction

Hello, Could you please share you experience on pushing through a major compaction on a CF with a large number of sstables? I get an OOM even after dropping CFs that I can drop and increasing JVM heap to the limit. My caches are minimal and memtables are empty. This only happens on a single nod

Re: How to store a list of values?

I was given one other suggestion (which may have been suggested earlier in this thread, but is clearer to me with an example). The suggestion was to use composite columns and have the first part of the key name be "skill" and the second part be the specific skill and then store a null value. I ho

Advice on architecture

Hello. I'm developing a system that will require me to store large (<=4MB) columns in Cassandra. Right now I'm storing 1 column per row, in a single CF. The machines I have at my disposal are 32GB RAM machines with 10 SATA drives each. I would prefer to have a larger number of smaller nodes, bu

Re: nodetool ring runs very slow

Hi Jonathan, similar problem happens again and there is only one GC running at that time per system.log.  This is one node of a 6-node 0.8.6 ring. Heap size on this host is 16GB. [fengqu@slcdbx1035 cassandra]$ date; time cnt ring Tue Mar 27 09:24:20 GMT+7 2012 Address DC  Rack   

Re: nodetool ring runs very slow

Haven't received any reply. Resend...   Feng Qu > > From: Feng Qu >To: Cassandra User Group >Sent: Wednesday, February 22, 2012 1:49 PM >Subject: nodetool ring runs very slow > > >We noticed that nodetool ring sometimes returns in 17-20 sec while it normally >

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: Schema advice/help

multiget does not require OPP. On 27/03/2012 09:51, Maciej Miklas wrote: 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://pkghosh.wordpress.com/201

cqlsh

How do i use the cqlsh comand line utility?? I m using cassandra 1.0.8.. Does cqlsh command line utility comes with the download of cassandra 1.0.8 or we have to do it separately. Suggest a way to go further plz reply :)

Re: counter column family

now i want to have a field incrementing with every row insertion. how do i do it in cassandra?? On Tue, Mar 27, 2012 at 7:34 PM, Dave Brosius wrote: > Counter columns are special, they must be in a column family to > themselves. > > On 03/27/2012 09:32 AM, puneet loya wrote: > > wen i m using a

Re: counter column family

Counter columns are special, they must be in a column family to themselves. On 03/27/2012 09:32 AM, puneet loya wrote: wen i m using a counter column.. i m nt able to add columns of other type to the column family.. is it so or it is just synactical error?? [default@CMDCv99] create column fami

Re: Cannot start cassandra node anymore

Hi Carlo, Can you post steps to reproduce over on https://issues.apache.org/jira/browse/CASSANDRA-3819 ? We have tried and failed to cause this problem. On Thu, Jan 26, 2012 at 6:24 AM, Carlo Pires wrote: > I found out this is related to schema change. Happens *every time* I create > drop and n

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

Thanks for the quick feedback. I will drop the schema then. Benoit. Le 27 mars 2012 14:50, Sylvain Lebresne a écrit : > Actually, there was a few changes to the on-disk format of schema > between beta1 and beta2 so upgrade is not supported between those two > beta versions. > Sorry for any inc

Re: counter column family

wen i m using a counter column.. i m nt able to add columns of other type to the column family.. is it so or it is just synactical error?? [default@CMDCv99] create column family status ... with comparator = AsciiType ... and column_metadata = ... [{ ... column_n

Re: counter column family

You should use a connection pool without retries to prevent a "single" increment of +1 have a result of e.g. +3. 2012/3/27 Rishabh Agrawal > You can even define how much increment you want. But let me just warn > you, as far my knowledge, it has consistency issues. > > > > *From:* puneet loya [

import

I want to import files from excel to cassandra? Is it possible?? Any tool that can help?? Whats the best way?? Plz reply :)

Re: create column family

how to use cql?? Rite now i m running dis file cassandra-cli.bat i connect localhost/9160; den i went into use pun; //its a keyspace using the create statement create COLUMNFAMILY users (KY uuid PRIMARY KEY*,* firstname text, lastname text, email text, address text, zip int, state tex

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

Actually, there was a few changes to the on-disk format of schema between beta1 and beta2 so upgrade is not supported between those two beta versions. Sorry for any inconvenience. -- Sylvain On Tue, Mar 27, 2012 at 12:57 PM, Benoit Perroud wrote: > Hi All, > > Thanks a lot for the release. > I j

RE: counter column family

You can even define how much increment you want. But let me just warn you, as far my knowledge, it has consistency issues. From: puneet loya [mailto:puneetl...@gmail.com] Sent: Tuesday, March 27, 2012 5:59 PM To: user@cassandra.apache.org Subject: Re: counter column family thanxx a ton :) :) th

Re: counter column family

thanxx a ton :) :) the counter column family works synonymous as '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: > *create colu

create column family

create column family users (uuid PRIMARY KEY firstname text, lastname text, email text, address text, zip int, state text); Is dis above statement correct? I m getting an error " Syntax error at position 27: missing EOF at '(' " Do reply Can u suggest the most stable version of cassandra??

RE: counter column family

As far as I know counter column family may pose serious consistency issues as they don't store timestamp. Correct me if I am wrong. From: R. Verlangen [mailto:ro...@us2.nl] Sent: Tuesday, March 27, 2012 5:50 PM To: user@cassandra.apache.org Subject: Re: counter column family create column family

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: cassandra 1.08 on java7 and win7

create keyspace DEMO with placement_strategy = 'org.apache.cassandra.locator.NetworkTopologyStrategy' and strategy_options=[{datacenter1:1}]; try it n check if it executes On Tue, Mar 27, 2012 at 3:35 AM, Frank Hsueh wrote: > create keyspace via cassandra cli fails > https://issues.ap

counter column family

Can u give an example of create column family with counter column in it. Please reply Regards, Puneet Loya

Re: problem in create column family

create column family student with column_type = 'AsciiType' and column_metadata = [{ column_name : name, validation_class : 'AsciiType }]; On Tue, Mar 27, 2012 at 1:48 PM, Guy Incognito wrote: > why don't you show us the command you're actually trying to run? > > > On 27/03/2012 08:

Re: [BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

Hi All, Thanks a lot for the release. I just upgraded my 1.1-beta1 to 1.1-beta2, and I get the following error : INFO 10:56:17,089 Opening /app/cassandra/data/data/system/LocationInfo/system-LocationInfo-hc-18 (74 bytes) INFO 10:56:17,092 Opening /app/cassandra/data/data/system/LocationInfo/sys

[BETA RELEASE] Apache Cassandra 1.1.0-beta2 released

The Cassandra team is pleased to announce the release of the second beta for the future Apache Cassandra 1.1. Note that this is beta software and as such is *not* ready for production use. The goal of this release is to give a preview of what will become Cassandra 1.1 and to get wider testing bef

Re: Schema advice/help

@R. Verlangen: You are suggesting to keep a single row for all activities & read all the columns from the row & then filter, right!? If done that way (instead of keeping it in 5 rows) then I would need to retrieve 100s-200s of columns from single row rather than just 50 columns if I keep in 5 rows

Re: tombstones problem with 1.0.8

Dne 27.3.2012 11:13, Ross Black napsal(a): Any pointers on what I should be looking for in our application that would be stopping the deletion of tombstones? do not delete already deleted rows. On read cassandra returns deleted rows as empty in range slices.

Re: tombstones problem with 1.0.8

Any pointers on what I should be looking for in our application that would be stopping the deletion of tombstones? Thanks, Ross On 26 March 2012 16:27, Viktor Jevdokimov wrote: > Upon read from S1 & S6 rows are merged, T3 timestamp wins. > T1 will be deleted upon S1 compaction with S6 or manual

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: Schema advice/help

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://pkghosh.wordpress.com/2011/03/02/cassandra-secondary-index-patterns/ On Tue, Mar 27, 2012 at 10:10 AM

Re: problem in create column family

why don't you show us the command you're actually trying to run? On 27/03/2012 08:52, puneet loya wrote: I m using cassandra 1.0.8.. Please reply On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen > wrote: Not sure about that, what version of Cassandra are you using?

Re: Schema advice/help

without the ability to do disjoint column slices, i would probably use 5 different rows. userId:itemType -> activityId then it's a multiget slice of 10 items from each of your 5 rows. On 26/03/2012 22:16, Ertio Lew wrote: I need to store activities by each user, on 5 items types. I always wan

Re: problem in create column family

I m using cassandra 1.0.8.. Please reply On Tue, Mar 27, 2012 at 12:28 PM, R. Verlangen wrote: > Not sure about that, what version of Cassandra are you using? Maybe > someone else here knows how to solve this.. > > > 2012/3/27 puneet loya > >> ya had created with UTF8Type before.. It gave the

Re: unbalanced ring

Thanks, I will wait and see as data accumulates. Thanks, *Tamar Fraenkel * Senior Software Engineer, TOK Media [image: Inline image 1] ta...@tok-media.com Tel: +972 2 6409736 Mob: +972 54 8356490 Fax: +972 2 5612956 On Tue, Mar 27, 2012 at 9:00 AM, R. Verlangen wrote: > Cassandra is

Re: How to store a list of values?

YEAH! agree, it only matter for time bucket data. On Tue, Mar 27, 2012 at 12:31 PM, R. Verlangen wrote: > 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. Verla

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's very simple: > configure > > the cluster name a

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 you mean? You don't have to specify the columns i

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 >