How to make cassandra reconize SSTable after reinstall?

2013-10-11 Thread Pin Siang Tan
Hi I have a single node Cassandra running datastax distribution. I reinstall Cassandra and updated cassandra.yaml data_file_directories. But now I run nodetool cfstats I got SSTable count: 0 This is the output of nodetool cfstats Keyspace: kairosdbRead Count: 0Read Latency: NaN ms. Write

COPY command times out

2013-10-11 Thread Petter von Dolwitz (Hem)
Hi, I'm trying to import CSV data using the COPY ... FROM command. After importing 10% of my 2.5 GB csv file the operation aborts with the message: Request did not complete within rpc_timeout. Aborting import at record #504631 (line 504632). Previously-inserted values still present. There are

Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread ashish sanadhya
I have done with bulk loader with key_validation_class=LexicalUUIDType for new row with the help of this [code][1] but i have changed my **key_validation_class=AsciiType** in order to make **string as row keys** create column family Users1 with key_validation_class=AsciiType

Re: COPY command times out

2013-10-11 Thread Vivek Mishra
If not getting any exception. Reason for Request did not complete within rpc_timeout. = socket time out As per http://www.datastax.com/docs/1.1/references/cql/COPY( COPY from CSV section) COPY FROM is intended for importing small datasets (a few million rows or less) into Cassandra. For

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
but i have changed my **key_validation_class=AsciiType** in order to make **string as row keys** why not key_validation_class=UTF8Type ? -Vivek On Fri, Oct 11, 2013 at 3:55 PM, ashish sanadhya sanadhyaa...@gmail.comwrote: I have done with bulk loader with key_validation_class=LexicalUUIDType

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
Also, please use ByteBufferUtils for byte conversions. On Fri, Oct 11, 2013 at 4:17 PM, Vivek Mishra mishra.v...@gmail.com wrote: but i have changed my **key_validation_class=AsciiType** in order to make **string as row keys** why not key_validation_class=UTF8Type ? -Vivek On Fri, Oct

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread ashish sanadhya
Hi vivek key_validation_class=UTF8Type will do ,but i certainly want *string as row keys, *so will it work ?? * * On Fri, Oct 11, 2013 at 4:17 PM, Vivek Mishra mishra.v...@gmail.com wrote: Also, please use ByteBufferUtils for byte conversions. On Fri, Oct 11, 2013 at 4:17 PM, Vivek Mishra

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
I am not able to get your meaning for *string as row keys ? * * * Row key values will be of type key_validation_class only * * On Fri, Oct 11, 2013 at 4:25 PM, ashish sanadhya sanadhyaa...@gmail.comwrote: Hi vivek key_validation_class=UTF8Type will do ,but i certainly want *string as row

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread ashish sanadhya
Here i mean that key_validation_class=AsciiType or key_validation_class=UTF8Type but I am unable to create an sstable for this column family create column family Users1 with key_validation_class=UTF8Type and comparator=AsciiType AND column_metadata = [ {column_name:

Re: Bulk Loader in cassandra : String as row keys in cassandra

2013-10-11 Thread Vivek Mishra
Change key_validation_class to UTF8Type and usersWriter.newRow(ByteBufferUtil.bytes(String.valueOf(lineNumber))); On Fri, Oct 11, 2013 at 4:42 PM, ashish sanadhya sanadhyaa...@gmail.comwrote: Here i mean that key_validation_class=AsciiType or key_validation_class=UTF8Type but I am unable

Re: COPY command times out

2013-10-11 Thread Petter von Dolwitz (Hem)
Hi, thanks for you reply. My CSV contained roughly 5 million rows. It aborted after half a million row. It seems to me that some throttling mechanism is missing in the implementation of the COPY command? I'll try the other way of getting data in. /Petter 2013/10/11 Vivek Mishra

Heap requirement for Off-heap space

2013-10-11 Thread Artur Kronenberg
Hi, I was playing around with cassandra off-heap options. I configured 3 GB off-heap for my row cache and 2 GB Heap space for cassandra. After running a bunch of load tests against it I saw the cache warm up. Doing a jmap histogram I noticed a lot of offHeapkey objects. At that point my row

Denial of Service Issue

2013-10-11 Thread Thorsten.Sinn
I found the issue below concerning inactive client connections (see Cassandra Securityhttp://jkb.netii.net/index.php/pub/sinosqldb/cassandra-security). We are using Cassandra 1.2.4 and the Cassandra JDBC driver as client. Is this still an existing issue? Quoted from site above: Denial of

Re: Cassandra Agent

2013-10-11 Thread Edward Capriolo
Stick sandra on the end. Restsandra. On Friday, October 11, 2013, Ran Tavory ran...@gmail.com wrote: Seems like the greeks are all used out, how about moving the the japanese mythology? it's a brand new pool of names... http://en.wikipedia.org/wiki/Japanese_mythology On Fri, Oct 11, 2013 at

Re: Cassandra Agent

2013-10-11 Thread David Schairer
http://en.wikipedia.org/wiki/List_of_children_of_Priam You've got plenty of children of Priam to go around. Doesn't anyone read the Iliad any more? :) --DRS On Oct 11, 2013, at 6:55 AM, Edward Capriolo edlinuxg...@gmail.com wrote: Stick sandra on the end. Restsandra. On Friday, October

Re: Cassandra Agent

2013-10-11 Thread Ran Tavory
Now that's a fun problem to solve! On 11 באוק 2013, at 17:17, David Schairer dschai...@humbaba.net wrote: http://en.wikipedia.org/wiki/List_of_children_of_Priam You've got plenty of children of Priam to go around. Doesn't anyone read the Iliad any more? :) --DRS On Oct 11, 2013,

Re: Denial of Service Issue

2013-10-11 Thread Richard Low
On 11 October 2013 14:03, thorsten.s...@t-systems.com wrote: I found the issue below concerning inactive client connections (see *Cassandra Security*http://jkb.netii.net/index.php/pub/sinosqldb/cassandra-security). We are using Cassandra 1.2.4 and the Cassandra JDBC driver as client. Is

Re: Denial of Service Issue

2013-10-11 Thread Edward Capriolo
While you normally would not allow access to a MySQL server, it is done in many instances like shared hosting. Also mysql does support a max fail connection attempts feature that will blacklist an IP for a time. On Fri, Oct 11, 2013 at 3:37 PM, Richard Low rich...@wentnet.com wrote: On 11

Re: Heap requirement for Off-heap space

2013-10-11 Thread Robert Coli
On Fri, Oct 11, 2013 at 5:47 AM, Artur Kronenberg artur.kronenb...@openmarket.com wrote: I was playing around with cassandra off-heap options. I configured 3 GB off-heap for my row cache and 2 GB Heap space for cassandra. The row cache is only really useful in very specific cases involving

vnode + multi dc migration

2013-10-11 Thread Chris Burroughs
I know there is a good deal of interest [1] on feasible methods for enabling vnodes on clusters that did not start with them. We recently completed a migration from a production cluster not using vnodes and in a single DC to one using vnodes in two DCs. We used the just spin up a new DC and

Re: Cassandra Agent

2013-10-11 Thread Sean McCully
On Friday, October 11, 2013 09:55:36 AM Edward Capriolo wrote: Stick sandra on the end. Restsandra. Polites, isn't a rest API wrapper for Cassandra really, it does more configuration and management of a Cassandra Node. Though it does have a REST API On Friday, October 11, 2013, Ran

Re: Cassandra Agent

2013-10-11 Thread Sean McCully
On Friday, October 11, 2013 07:17:53 AM David Schairer wrote: http://en.wikipedia.org/wiki/List_of_children_of_Priam You've got plenty of children of Priam to go around. Doesn't anyone read the Iliad any more? :) --DRS And so we have Polites, https://github.com/seanmccully/polites