Re: anyone using Cassandra as an analytics/data warehouse?

2011-01-09 Thread Peter Harrison
On Wed, Jan 5, 2011 at 4:09 PM, Dave Viner wrote: > > "a Column Family with the row key being the Unix time divided by 60x60 and > a column key of... pretty much anything unique" > LogCF[hour-day-in-epoch-seconds][timeuuid] = 1 > where 'hour-day-in-epoch-seconds' is something like the first s

Re: anyone using Cassandra as an analytics/data warehouse?

2011-01-04 Thread Peter Harrison
Okay, here is two ways to handle this, both are quite different from each other. A) This approach does not depend on counters. You simply have a Column Family with the row key being the Unix time divided by 60x60 and a column key of... pretty much anything unique. Then have another process look

Insert after Delete fails silently

2010-09-30 Thread Peter Harrison
If you delete a row, and it therefore is marked as tombstone, and subsequently you try to insert the row again it appears to succeed, but if you try to request the row you don't get a result. If you try to insert a row that has been recently deleted, and has an active tombstone I would expect eith

Automatic Indexing on Composite Keys & Unions

2010-09-12 Thread Peter Harrison
I'm looking at how to achieve a search on several separate fields. Before 0.7.0 this would mean separate indexes maintained by explicit mutations by the client. Recently automatic secondary indexes were added to 0.7.0. I have several indexes. My index row keys are composite keys. All the indexes ar

Azure Cloud Storage - Tables

2010-09-08 Thread Peter Harrison
Microsoft has essentially copied the Cassandra approach for it's Table Storage. See here: http://www.codeproject.com/KB/azure/AzureStorage.aspx It is I believe a compliment of sorts, in the sense that it is a validation of the Cassandra approach. The reason I know about this is that I attended a

Re: connect to cassandra using java

2010-09-07 Thread Peter Harrison
On Wed, Sep 8, 2010 at 3:20 AM, Asif Jan wrote: > > > Hi > I need to use the low level java API in order to test bulk ingestion to > cassandra. I have already looked at the code in contrib/bmt_example and > contrib/client_only. > When I try and run the following code, I get following exception ; u

Re: Index feature in 0.7

2010-08-23 Thread Peter Harrison
On Fri, Aug 13, 2010 at 11:15 PM, Carlos Sanchez wrote: > All, > > I was wondering if I could get some information (link / pdf) about the new > [column] indices in Cassandra for version 0.7 > Seconded; specifically I was wondering if you can define the secondary indexes inside cassandra.yaml, an

Re: cassandra.yaml after a schema import

2010-08-23 Thread Peter Harrison
On Tue, Aug 24, 2010 at 12:28 AM, aaron morton wrote: > I think this may have been discussed before, but I cannot find any reference > to it. Just wanted to confirm how cassandra.yaml is used after the cluster is > initialised. > > Start a clean install of 0.7b1, use jconsole to import the schem

Re: [RELEASE] 0.7.0 beta1

2010-08-22 Thread Peter Harrison
On Thu, Aug 19, 2010 at 12:34 AM, Ran Tavory wrote: > Happy to announce hector's support in 0.7.0. Hector is a java client for > cassandra which wraps the low level thrift interface with a nicer API, adds > monitoring, connection pooling and more. > I didn't do anything... The amazing 0.7.0 work

Cassandra 0.7.0 beta1 - Unable to find property 'thrift_framed_transport_size_in_mb'

2010-08-16 Thread Peter Harrison
Hi everyone, I'm trying to to get the beta of 0.7.0 up and running. I have had a previous build from a couple of weeks ago working okay; one that I built myself from source. >From both a recent build of Cassandra from source and from the distributed binaries I am getting the following on start: #

Re: How to migrate any relational database to Cassandra

2010-08-06 Thread Peter Harrison
On Sat, Aug 7, 2010 at 6:00 AM, sonia gehlot wrote: > Can you please help me how to move forward? How should I do all the setup > for this? My view is that Cassandra is fundamentally different from SQL databases. There may be artefact's which are superficially similar between the two systems, bu

Re: Using Pelops with Cassandra 0.7.X

2010-07-13 Thread Peter Harrison
On Wed, Jul 14, 2010 at 2:43 PM, Dan Washusen wrote: > http://github.com/danwashusen/pelops/tree/cassandra-0.7.0 Doh - I've just finished making most of the changes for the new API. > p.s. Pelops doesn't have any test coverage and my implicit tests (my app > integration tests) don't touch anywhe

Using Pelops with Cassandra 0.7.X

2010-07-13 Thread Peter Harrison
I know Cassandra 0.7 isn't released yet, but I was wondering if anyone has used Pelops with the latest builds of Cassandra? I'm having some issues, but I wanted to make sure that somebody else isn't working on a branch of Pelops to support Cassandra 7. I have downloaded and built the latest code fr