Cassandra 0.7 example

2010-09-02 Thread Thorvaldsson Justus
Courtney Robinson [sa...@live.co.uk] Hello everyone, I'm sorry if that has been asked already, i've just joined the list. can anyone provide a quick java example of connecting to cassandra and setting up a keyspace and a column family using thrift. I know my way around 0.6 and i'm trying

Server problem C 0.6.5

2010-09-01 Thread Thorvaldsson Justus
Ok I have two test servers, they are RH and pretty nice. I have two problems with one of them and none with the other. Same configuration but the seed and listen address that is their opposites. Nothing fancy. RF=2 All info I can get is also here and some more like conf, 590 rows

dont mind my last letter (server problem)

2010-09-01 Thread Thorvaldsson Justus
Or this one =) Server error was indeed an error but on my behalf. If you try to memlock more than available memory on server it will kernel crash Also If you use swap as ram it will be having a lot of trouble /J AB SVENSKA SPEL 106 10 Stockholm Sturegatan 11, Sundbyberg Växel +46 8 757 77 00

SV: Replication factor and other schema changes in = 0.7

2010-08-20 Thread Thorvaldsson Justus
KsDef CfDef -has metadata And perhaps ColumnDef how to make a ksdef--- KsDef k = new KsDef(); k.setName(keyspacename); k.setReplication_factor(replicafactor); k.setStrategy_class(org.apache.cassandra.locator.RackUnawareStrategy); ListCfDef cfDefs = new ArrayListCfDef();

SV: Poor performance; PHP amp; Thrift to blame

2010-08-20 Thread Thorvaldsson Justus
Seach the mailing list http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/ This is already been addressed and is a php issue only The time 5 sec is a timeout because if I remember correctly packet size is too small or something like it You can config so it stops being a porblem but

SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Thorvaldsson Justus
? or do I have to develop it myself? Are there any documentation on plugin development for Cassandra? Best regards Jone On 19/08/2010 08:42, Thorvaldsson Justus wrote: You should iterate through them, get 200 then go get the next 200 and so on. Also if checking a bounding box to another

SV: SV: SV: Help with getting Key range with some column limitations

2010-08-20 Thread Thorvaldsson Justus
minutes. Jone On 20/08/2010 10:05, Thorvaldsson Justus wrote: I think you should try to do it some other way than iterate, it sounds super suboptimal to me. Also the plugin option he was thinking of I think is changing Cassandra sourcecode, kind of hard when Cassandra is changing so fast

SV: Help with getting Key range with some column limitations

2010-08-19 Thread Thorvaldsson Justus
You should iterate through them, get 200 then go get the next 200 and so on. Also if checking a bounding box to another.. perhaps try sorting them so you could start looking at both ends, perhaps make the iteration smaller until match somehow? Just my simple coins, also upgrading will probably

SV: Cassandra gem

2010-08-17 Thread Thorvaldsson Justus
Using beta, made a describe_version(), got 10.0.0 as reply, aint using gem though, just thrift from java /Justus -Ursprungligt meddelande- Från: Benjamin Black [mailto:b...@b3k.us] Skickat: den 17 augusti 2010 08:37 Till: user@cassandra.apache.org Ämne: Re: Cassandra gem I'm testing

How to use Secondary Indices 0.7.0beta1

2010-08-17 Thread Thorvaldsson Justus
I figured some but I am stuck, would appreciate help a lot to understand how to use secondary indices. Create a Column family and define the secondary indices CfDef cdef = new CfDef(); cdef.setColumn_type(columntype); cdef.setComment(comment); cdef.setComparator_type(comparatortype);

SV: The entry of Cassandra

2010-08-16 Thread Thorvaldsson Justus
http://wiki.apache.org/cassandra/ClientOptions but I prefer writing my own code, trying to write something simple API working with 0.7.0beta1 amt though am I the only one that thinks NOT using clients like hector is simpler (in a way, to feel in control at least)? Från: Ying Tang

SV: The entry of Cassandra

2010-08-16 Thread Thorvaldsson Justus
of Cassandra You mean list a few hosts and connect them in a round robin , like Tavory said? On Mon, Aug 16, 2010 at 8:36 PM, Thorvaldsson Justus justus.thorvalds...@svenskaspel.semailto:justus.thorvalds...@svenskaspel.se wrote: http://wiki.apache.org/cassandra/ClientOptions but I prefer writing my

SV: how to retrieve data from supercolumns by phpcassa ?

2010-08-13 Thread Thorvaldsson Justus
I don't use php so I don't know the method but http://wiki.apache.org/cassandra/API get ColumnOrSuperColumn get(string keyspace, string key, ColumnPath column_path, ConsistencyLevel consistency_level) Get the Column or SuperColumn at the given column_path. If no value is present,

SV: Using Cassandra for storing measurement data

2010-08-03 Thread Thorvaldsson Justus
It sounds to me that it's an good idea to use Cassandra in your case, I figure I help you as we Europeans need to cooperate some even though I only worked with Cassandra for a month. =) 1: What is the query you want to use when charting the data? Use it to decide how to storage and sort your

SV: Consequences of Cassandra key NOT unique

2010-07-29 Thread Thorvaldsson Justus
You insert 500 rows with key x And 1000 rows with key y You make a query getting all rows. It will only show two rows, the ones with the latest timestamps. /Justus Från: Rana Aich [mailto:aichr...@gmail.com] Skickat: den 29 juli 2010 08:23 Till: user@cassandra.apache.org Ämne: Re: Consequences of

Differencing test results

2010-07-29 Thread Thorvaldsson Justus
I am testing on one node only right now and simply adding data and reading it. There is no real problem but I feel I get differencing results from the tests depending on something I would like to know what it is. What is happening between two points in time --Here is a point with Slower result

SV: Help! Cassandra Data Loader threads are getting stuck

2010-07-27 Thread Thorvaldsson Justus
I made one program doing just this with Java Basically I read with one thread from file into an array stopping when size is 20k and w8 until it is less than 20k and continue reading the datafile. (this is the raw data I want to move) I have n number of threads Each with one batch of their own

SV: Key Caching

2010-07-27 Thread Thorvaldsson Justus
I can test on 3 servers and I can test using up to 86gb on each, is there anything specific you want to test in this case? I am using Cassandra 6.3 and running a much smaller amount of RAM but if you think it is interesting I will add it to my ToDo list. I don’t know if I will have more servers

SV: How to stop cassandra server, installed from debian/ubuntu package

2010-07-26 Thread Thorvaldsson Justus
I use standard close, CTRL C, I don't run it as deamon Dunno but think it works fine =) -Ursprungligt meddelande- Från: o...@notrly.com [mailto:o...@notrly.com] Skickat: den 26 juli 2010 15:52 Till: user@cassandra.apache.org Ämne: How to stop cassandra server, installed from

SV: What is consuming the heap?

2010-07-20 Thread Thorvaldsson Justus
Supercolumn/column must fit into node memory It could be? /Justus Från: 王一锋 [mailto:wangyif...@aspire-tech.com] Skickat: den 20 juli 2010 08:48 Till: user Ämne: What is consuming the heap? In my cluster, I have set both KeysCached and RowsCached of my column family on all nodes to 0, but it

SV: key types and grouping related rows together

2010-07-15 Thread Thorvaldsson Justus
Dont forget you can make your own sorting algorithm. Here is a nice tutorial for that. http://www.sodeso.nl/?p=421 Justus Från: Schubert Zhang [mailto:zson...@gmail.com] Skickat: den 15 juli 2010 04:20 Till: user@cassandra.apache.org Ämne: Re: key types and grouping related rows together for

SV: Query on delete a column inside a super column

2010-07-07 Thread Thorvaldsson Justus
This is my first email, just started with Cassandra, I think you want to use Mutate object or something like it The Mutation object can also be used to create new Columns or to delete a Column, if you supply it with a key that doesn't exist in the database it will create it, if it detects that