Re: Need help json2sstable

You are missing " after On Wed, Jul 20, 2011 at 8:03 AM, Nilabja Banerjee wrote: > Hi All, > > Here Is my Json structure. > > > {"Fetch_CC" :{ >                 "cc":{ "":"1000", >                     ":"ICICI", >                          "":"", >               

Need help json2sstable

Hi All, Here Is my Json structure. {"Fetch_CC" :{ "cc":{ "":"1000", ":"ICICI", "":"", "city":{ "name":"banglore" };

Re: Repair taking a long, long time

Thanks Edward. I'm told by our IT that the switch connecting the nodes is pretty fast. Seriously, in my house I copy complete DVD images from my bedroom to the living room downstairs via WiFi, and a dozen of GB does not seem like a problem, on dirt cheap hardware (Patriot Box Office). I also hav

Re: Is anyone actually seriously using SimpleAuthenticator and SimpleAuthority?

We studied SimpleAuthority a few months back out of curiosity and took some notes on it to eventually use it in the future. Somebody getting started with this might find the following helpful... - - - - - - The following discusses ways to configure security best practices for a Cassandra cluster

PHPCassa get number of rows

Hi, How can I get the number of rows with PHPCassa? Thanks in advance.

Is anyone actually seriously using SimpleAuthenticator and SimpleAuthority?

See: https://issues.apache.org/jira/browse/CASSANDRA-2922 -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com

Re: Custom Authentication with Cassandra

It lets you insert data as if you were authorized? On Tue, Jul 19, 2011 at 2:55 PM, Chandrasekhar M wrote: > Hi, > > Appears to me that the CLI allows login even though there is an > authentication exception. > > At that point there is actually no user id/pwd, ie, both are empty strings. > > If

RE: Custom Authentication with Cassandra

Hi, Appears to me that the CLI allows login even though there is an authentication exception. At that point there is actually no user id/pwd, ie, both are empty strings. If necessary, I can send the code, I am using for the CustomAuthentication. Regards Chandra -Original Message- From

Re: Is there a way to read a Double value from the CLI?

k, thanks for the clarification Nate. On Tue, Jul 19, 2011 at 10:14 AM, Nate McCall wrote: > The DoubleSerializer in Hector predates Cassandra's DoubleType and was > thus designed to stick values in a LongType or BytesType comparator. > Because of this, we are calling Double.doubleToRawLongBits

Re: Too many open files during Repair operation

If you are using Linux, especially Ubuntu, check the linked document below. This is my favorite: "Using sudo has side effects in terms of open file limits. On Ubuntu they’ll be reset to 1024, no matter what’s set in /etc/security/limits.conf" http://wiki.basho.com/Open-Files-Limit.html /Attila

Re: Is there a way to read a Double value from the CLI?

The DoubleSerializer in Hector predates Cassandra's DoubleType and was thus designed to stick values in a LongType or BytesType comparator. Because of this, we are calling Double.doubleToRawLongBits and Double.longBitsToDouble underneath, so this may not be what you expect. I'll add another serial

Re: Too many open files during Repair operation

I'm guessing you've seen this already? http://www.datastax.com/docs/0.8/troubleshooting/index#java-reports-an-error-saying-there-are-too-many-open-files Check out the # of File Descriptors opened with the "lsof- -n | grep java" command. On Tue, Jul 19, 2011 at 8:30 AM, cbert...@libero.it wrote:

Re: nodetool repair mykeyspace mycolumnfamily repairs all the keyspace

Short answer: no. Long answer: https://issues.apache.org/jira/browse/CASSANDRA-2818 2011/7/19 Héctor Izquierdo Seliva : > Are there any plans to backport this to 0.8? > > El mar, 19-07-2011 a las 11:43 -0500, Jonathan Ellis escribió: >> https://issues.apache.org/jira/browse/CASSANDRA-2280 >> >> 2

Re: nodetool repair mykeyspace mycolumnfamily repairs all the keyspace

Are there any plans to backport this to 0.8? El mar, 19-07-2011 a las 11:43 -0500, Jonathan Ellis escribió: > https://issues.apache.org/jira/browse/CASSANDRA-2280 > > 2011/7/19 Héctor Izquierdo Seliva : > > Hi all, > > > > Maybe I'm doing something wrong, but calling ./nodetool -h repair > > myk

Re: nodetool repair mykeyspace mycolumnfamily repairs all the keyspace

https://issues.apache.org/jira/browse/CASSANDRA-2280 2011/7/19 Héctor Izquierdo Seliva : > Hi all, > > Maybe I'm doing something wrong, but calling ./nodetool -h repair > mykeyspace mycolumnfamily should only repair mycolumnfamily right? > Everytime I try a repair it repairs the whole key space i

nodetool repair mykeyspace mycolumnfamily repairs all the keyspace

Hi all, Maybe I'm doing something wrong, but calling ./nodetool -h repair mykeyspace mycolumnfamily should only repair mycolumnfamily right? Everytime I try a repair it repairs the whole key space instead of just one column family. I'm on cassandra 0.8.1

Re: Repair taking a long, long time

On Tue, Jul 19, 2011 at 11:36 AM, Maxim Potekhin wrote: > Thanks for pointer. As a comment to your disk speed comment -- > I had already installed SSDs on these nodes. > > Maxim > > > On 7/19/2011 9:41 AM, Edward Capriolo wrote: > > > > On Tue, Jul 19, 2011 at 7:24 AM, Maxim Potekhin wrote: > >

Re: Repair taking a long, long time

Thanks for pointer. As a comment to your disk speed comment -- I had already installed SSDs on these nodes. Maxim On 7/19/2011 9:41 AM, Edward Capriolo wrote: On Tue, Jul 19, 2011 at 7:24 AM, Maxim Potekhin > wrote: We have something of the order of 200GB load

Too many open files during Repair operation

Hi all. In production we want to run nodetool repair but each time we do it we get the too many open files error. We've increased the number of available FD for Cassandra till 8192 but still we get the same error after few seconds. Should I increase it more? WARN [Thread-7] 2011-07-19 12:34:00,

Re: Custom Authentication with Cassandra

On Tue, Jul 19, 2011 at 5:50 AM, Chandrasekhar M wrote: > If one logs into the client (Cassandra Cli) without a userid or password, an > exception is thrown, but login happens into the shell as default@unknown. Are you really authenticated at that point or does the cli just not know how to deal w

Re: deletion questions

Konstantin, I've found that dropping a column family creates a snapshot quietly. So I gave it a "./nodetool clearsnapshot" command and the stale files were deleted. On Tue, Jul 19, 2011 at 6:26 PM, Konstantin Naryshkin wrote: > "2. Trying to reduce disk occupation I deleted CF which used 90% of

Re: deletion questions

"2. Trying to reduce disk occupation I deleted CF which used 90% of available space. After issuing a "drop column family User;" command no *User*.db files were deleted. "nodetool compact" haven't helped too. How can that deletion be triggered?" You have to wait for a garbage collect (or do a roll

deletion questions

Hello, I'm trying to use Cassandra 0.8.1 as a media storage where the stored items have some TTL. So that I need to somehow delete and purge obsoleted items. I've played with deletion columns from db by using Thift CassandraClient::remove call, but faced with the problem that sstable files become

Re: Repair taking a long, long time

On Tue, Jul 19, 2011 at 7:24 AM, Maxim Potekhin wrote: > We have something of the order of 200GB load on each of 3 machines in a > balanced cluster under 0.8.1. > I started repair about 24hrs ago and did some moderate amount of inserts > since then (a small fraction of > data load). The repair st

Repair taking a long, long time

We have something of the order of 200GB load on each of 3 machines in a balanced cluster under 0.8.1. I started repair about 24hrs ago and did some moderate amount of inserts since then (a small fraction of data load). The repair still appears to be running. What could go wrong? Thanks, Maxim

Custom Authentication with Cassandra

Hi, We are trying out Custom Authentication (with Database) with Cassandra, by implementing IAuthenticator interface. We are storing the following details in a properties file and passing the location of the properties file as a startup parameter to Cassandra 1. DB URL 2. DB User

Re: copy data from multi-node cluster to single node

Thanks for the info. I have not had time yet to try it with 0.7.6 but I got something working for 0.7.5 by copying back the system keyspace. Ross On 5 July 2011 10:58, aaron morton wrote: > How do you change the name of a cluster? The FAQ instructions do not seem > to work for me - are they

json2sstable & sstable2json

Hi All, Can you please explain me how can I use json2sstable and sstable2json features in cassandra. It will be useful to me if anyone of you explain me with a small example. 1. one small json text file. 2. what will be the keyspace and columnfamily name. 3. Syntax in details. What .db name I have

Re: How to keep only exactly column of key

On Tue, Jul 19, 2011 at 10:15 AM, Lior Golan wrote: > Can't this capping be done (approximately) during compaction. Something > like: > > 1.   Ability to define for a column family that it's a "capped > collection" with at most N columns per row > > 2.   During write – just add the column

RE: How to keep only exactly column of key

Can't this capping be done (approximately) during compaction. Something like: 1. Ability to define for a column family that it's a "capped collection" with at most N columns per row 2. During write - just add the column 3. During reads - get a slice with the most recent / top

Re: How to keep only exactly column of key

Speaking from practical experience, it is possible to simulate this feature by retrieving a slice of your row that only contains the most recent 100 items. You can then prevent the rows from growing out of control by checking the size of the row and pruning it back to 100 every N writes, where N is