SV: how to retrieve data from supercolumns by phpcassa ?

2010-08-12 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, NotFoundExcep

Re: 0.7 CLI w/TSocket

2010-08-12 Thread Mark
On 8/12/10 10:20 PM, Mark wrote: On 8/12/10 9:14 PM, Jonathan Ellis wrote: Works fine here. bin/cassandra-cli --host localhost --port 9160 Connected to: "Test Cluster" on localhost/9160 Welcome to cassandra CLI. On Thu, Aug 12, 2010 at 2:18 PM, Mark wrote: On 8/12/10 8:29 AM, Mark wrote: On

Re: 0.7 CLI w/TSocket

2010-08-12 Thread Mark
On 8/12/10 9:14 PM, Jonathan Ellis wrote: Works fine here. bin/cassandra-cli --host localhost --port 9160 Connected to: "Test Cluster" on localhost/9160 Welcome to cassandra CLI. On Thu, Aug 12, 2010 at 2:18 PM, Mark wrote: On 8/12/10 8:29 AM, Mark wrote: On 8/11/10 10:11 PM, Jonat

Re: 0.7 CLI w/TSocket

2010-08-12 Thread Jonathan Ellis
Works fine here. bin/cassandra-cli --host localhost --port 9160 Connected to: "Test Cluster" on localhost/9160 Welcome to cassandra CLI. On Thu, Aug 12, 2010 at 2:18 PM, Mark wrote: > On 8/12/10 8:29 AM, Mark wrote: >> >> On 8/11/10 10:11 PM, Jonathan Ellis wrote: >>> >>> you have to use an up t

Re: How does cfstats calculate Row Size?

2010-08-12 Thread Jonathan Ellis
Right, row stats in 0.6 are just "what I've seen during the compactions that happened to run since this node restarted last." 0.7 has persistent (and more fine-grained) statistics. On Thu, Aug 12, 2010 at 1:28 PM, Ryan King wrote: > On Thu, Aug 12, 2010 at 9:08 AM, Julie wrote: >> I am chasing

RE: error using get_range_slice with random partitioner

2010-08-12 Thread David McIntosh
I'm also seeing an issue with not being able to iterate over all keys in Cassandra 0.6.4. In my unit test I create 20 keys (0-19) and iterate with a batch size of 6. This is what I get. Cassandra 0.6.4 start key: "" 9, 14, 4, 15, 11, 18 start key: 18 18, 7, 17, 7, 17 start key:17 17

Re: 0.7 CLI w/TSocket

2010-08-12 Thread Mark
On 8/12/10 8:29 AM, Mark wrote: On 8/11/10 10:11 PM, Jonathan Ellis wrote: you have to use an up to date CLI, the old one used broken options w/ its framed mode On Wed, Aug 11, 2010 at 6:39 PM, Mark wrote: "org.apache.thrift.protocol.TProtocolException: Missing version in readMessageBegin, ol

Re: Can I retrieve specific key range from a table in RandomPartitioner?

2010-08-12 Thread Aaron Morton
Try setting the end key to an empty string, and then set the number of rows to something sane and make multiple calls if needed. Or you may be able to make your own secondary index another CF, so you do two reads: one on the secondary index then one of the rows you want.There has been some discussi

Re: How does cfstats calculate Row Size?

2010-08-12 Thread Ryan King
On Thu, Aug 12, 2010 at 9:08 AM, Julie wrote: > I am chasing down a row size discrepancy and am confused. > > I populated a single node Cassandra cluster with 10,000 rows of data, using > numeric keys 1-10,000, where each row is a little over 100kB in length and has > a single column in it. > > Wh

Re: Data Distribution / Replication

2010-08-12 Thread Benjamin Black
On Thu, Aug 12, 2010 at 8:30 AM, Stefan Kaufmann wrote: > Hello again, > > last day's I started several tests with Cassandra and learned quite some > facts. > > However, of course, there are still enough things I need to > understand. One thing is, how the data replication works. > For my Testing

Re: Filesystem for Cassandra

2010-08-12 Thread Peter Schuller
> Actually we use Cassandra on ZFS (OpenSolaris) - fine tuned for our need. no > Raidcontroller used. An interesting property of ZFS is the use of the ARC for caching. Contrary to the traditional behavior of buffer caches, the ARC should theoretically not evict all interesting data as a result of

Re: Post on experiences with Cassandra for Twitter retweet analysis

2010-08-12 Thread Eric Evans
On Thu, 2010-08-12 at 11:29 +0200, Mikio Braun wrote: > So far, we're very pleased with Cassandra performance, but we've also > had to overcome some issues on which I report in the blog and which > are hopefully interesting for other users of Cassandra. > > The blog post can be found here: > > ht

How does cfstats calculate Row Size?

2010-08-12 Thread Julie
I am chasing down a row size discrepancy and am confused. I populated a single node Cassandra cluster with 10,000 rows of data, using numeric keys 1-10,000, where each row is a little over 100kB in length and has a single column in it. When I perform a cfstats on the node immediately after wri

Data Distribution / Replication

2010-08-12 Thread Stefan Kaufmann
Hello again, last day's I started several tests with Cassandra and learned quite some facts. However, of course, there are still enough things I need to understand. One thing is, how the data replication works. For my Testing: 1. I set the replication Factor to 3, started with 1 active node (the

Re: 0.7 CLI w/TSocket

2010-08-12 Thread Mark
On 8/11/10 10:11 PM, Jonathan Ellis wrote: you have to use an up to date CLI, the old one used broken options w/ its framed mode On Wed, Aug 11, 2010 at 6:39 PM, Mark wrote: "org.apache.thrift.protocol.TProtocolException: Missing version in readMessageBegin, old client?" Is the CLI not su

how to retrieve data from supercolumns by phpcassa ?

2010-08-12 Thread lisek
Hi all, I've got cassandra superlcolumn looking like that: now in this columnfamily I've inserted something like that: ["client"] => array(1) { ["2a3909c0-a612-11df-b27e-346336336631"]=> array(3) { ["add_date"]=> string(10) "1281618279" ["lastname"]=> string(8) "

Re: Reload/Update schema 0.7

2010-08-12 Thread Gary Dusbabek
You should take a look at http://wiki.apache.org/cassandra/LiveSchemaUpdates loadSchemaFromYaml() is intended to initialize the schema on a seed node in a new cluster (or one that has been upgraded from 0.6). It is an operation that should only be performed one time *per cluster.* Gary On Wed,

Filesystem for Cassandra

2010-08-12 Thread Michael Widmann
Hi out there ... Without starting an OT Thread or an Evangelists war it would be interesting what filesystems most cassandra installation uses, which performs best in which cases Actually we use Cassandra on ZFS (OpenSolaris) - fine tuned for our need. no Raidcontroller used. What are the expe

Post on experiences with Cassandra for Twitter retweet analysis

2010-08-12 Thread Mikio Braun
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I've put a blog post where I discuss our experiences with using Cassandra as the main database backend for twimpact. Twimpact is research project at the TU Berlin which aims at estimating user impact based on retweet analysis. A live version of

Re: Can I retrieve specific key range from a table in RandomPartitioner?

2010-08-12 Thread ChingShen
I have a key range that between 00 and 001000, and my code as below: SlicePredicate predicate = new SlicePredicate(); predicate.setColumn_names(columns); ColumnParent parent = new ColumnParent(columnFamily); KeyRange k = new KeyRange(1000); k.setStart_key(key[0]); k.setEnd_key(key[1000

Can I retrieve specific key range from a table in RandomPartitioner?

2010-08-12 Thread ChingShen
Hi all, Can I retrieve specific key range from a table in RandomPartitioner? Because I always got below exception: Exception in thread "main" InvalidRequestException(why:start key's md5 sorts after end key's md5. this is not allowed; you probably should not specify end key at all, under Random