You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Julio Carlos Barrera Juez <ju...@gmail.com> on 2010/03/22 13:49:31 UTC

Example of data model

Hi all, I need an example of cassandra storage to understand better the
datamodel. I mena, an example of a little application with his
storage-conf.xml file like a little commerce with a list of clients and
stock.

Thank's.

Re: Example of data model

Posted by Sandeep Kalidindi <de...@gmail.com>.
http://blog.evanweaver.com/articles/2009/07/06/up-and-running-with-cassandra/

Above link should help. He explains the data model and then gives an example
of building twitter like service on top of cassandra.

Cheers,
Deepu.

On Mon, Mar 22, 2010 at 6:19 PM, Julio Carlos Barrera Juez <
juliocarlos@gmail.com> wrote:

> Hi all, I need an example of cassandra storage to understand better the
> datamodel. I mena, an example of a little application with his
> storage-conf.xml file like a little commerce with a list of clients and
> stock.
>
> Thank's.
>

RE: Frustrations installing Cassandra on Windows

Posted by Raymond Wilson <Ra...@trimble.co.nz>.
I tried removing the ivy folder in \users\rwilson and then just running ant in the Cassandra folder.

 

This appeared to be working until it complained about the same issue with resolving dependencies L

 

I tried deleting the ivy jar file I downloaded via Google and rant Ant again. This time it complained about not being able to download the ivy jar.

 

Raymond.

 

From: Christopher Brind [mailto:christopher.brind@googlemail.com] 
Sent: Wednesday, 24 March 2010 10:26 p.m.
To: user@cassandra.apache.org
Subject: Re: Frustrations installing Cassandra on Windows

 

I don't know if there's some difference between building on Mac and Windows, but I just tried building from the latest git repo and that was fine.  

 

I also downloaded and built the 0.6 src tar ball from apache-cassandra-0.6.0-beta3-src.tar.gz <http://www.apache.org/dyn/closer.cgi?path=/cassandra/0.6.0/apache-cassandra-0.6.0-beta3-src.tar.gz>  and that was fine too.

 

Now you know you have Java and Ant setup properly, try removing your .ivy2 folder ( C:\Users\rwilson\.ivy2 )  and just running ant (don't specify a target).  The build script seems to do all the retrieve stuff, so you shouldn't need to do that manually.

 

Cheers,

Chris

 

 

 

On 24 March 2010 02:49, Raymond Wilson <Ra...@trimble.co.nz> wrote:

Hi,

I've been looking at using Cassandra as a distributed database for use
in our server software, which runs on Windows.

This afternoon I've been trying to get Cassandra installed and running.
Actually installing Cassandra was pretty easy, at least in the steps of
"Download it, setup CASSANDRA_HOME and fiddle with the storage
configuration file", however getting it to run has not been so easy.
Admittedly, this is my first ever attempt at installing and running this
system, so I'm a sort of monkey tester here ;)

Here's a brief run-down of the issues I ran into trying out Cassandra
6.0 Beta 3, after installing Java 6 u18 and Cassandra itself (following
the instructions in http://www.mattvv.com/hosting-cassandra-on-windows/,
which may be out of date)

1. On running Cassandra, I get messages about the system not being able
to locate a path. Eventually figure out that JAVA_HOME needs to point to
a location in the [Program files]\Java folder, rather that location
itself (newbie error)
2. After configuring JAVA_HOME correctly, I get errors that the new
logging jar can't be found. I realise I skipped the 'Ant ivy-retrieve'
step in the instructions. So I download and install Ant, configure
ANT_HOME and run it.
3. I then run Ant ivy-retrieve. Oops, Tools.jar is not present. After
some Googling I determine that I need the JAVA JDK, rather than the JRE
to run it. (If this is a BETA, why does it need the JDK, surely the JRE
alone is sufficient?) I then download and install JDK 6v18 and update my
JAVA_HOME path.
4. I then run Ant ivy-retrieve again. It starts running (great), then
fails with a generic error trying to get the ivy-2.1.0.jar file. I
copied the URL into Google which promptly downloaded it, so I'm not sure
what's wrong there. I copied the ivy-2.1.0.jar file into the build
folder and tried again
5. I then run Ant ivy-retrieve again, Success (sort of). The ant job
complains it can't get the file, then notices it's there after all and
proceeds to start building. That fails horribly with many error messages
in the command window.
6. I ran it again and captured the output (attached to the email). This
explains that lots of things couldn't be resolved.

Does anyone have a step-by-step, soup to nuts, from ground zero, list of
instructions to get Cassandra installed and running on a clean windows
system?

As a suggestion, is it worth considering producing Cassandra builds that
contain all the peripheral bits and pieces it relies on (essentially
running the 'ant ivy-retrieve' command and bundling up the results as a
single download/install) so that clueless newbie users like me have a
better chance getting this running?

Thanks,
Raymond.

 


RE: Frustrations installing Cassandra on Windows

Posted by Raymond Wilson <Ra...@trimble.co.nz>.
It turns out the issue is that I needed to set up a proxy via ANT_OPTS.

This seems to work now, even though the last thing the ant job does is say the build failed, it does appear to set everything up and Cassandra runs up and I can connect to it via Cassandra-cli

 

Thanks,

Raymond.

 

 

From: Christopher Brind [mailto:christopher.brind@googlemail.com] 
Sent: Wednesday, 24 March 2010 10:26 p.m.
To: user@cassandra.apache.org
Subject: Re: Frustrations installing Cassandra on Windows

 

I don't know if there's some difference between building on Mac and Windows, but I just tried building from the latest git repo and that was fine.  

 

I also downloaded and built the 0.6 src tar ball from apache-cassandra-0.6.0-beta3-src.tar.gz <http://www.apache.org/dyn/closer.cgi?path=/cassandra/0.6.0/apache-cassandra-0.6.0-beta3-src.tar.gz>  and that was fine too.

 

Now you know you have Java and Ant setup properly, try removing your .ivy2 folder ( C:\Users\rwilson\.ivy2 )  and just running ant (don't specify a target).  The build script seems to do all the retrieve stuff, so you shouldn't need to do that manually.

 

Cheers,

Chris

 

 

 

On 24 March 2010 02:49, Raymond Wilson <Ra...@trimble.co.nz> wrote:

Hi,

I've been looking at using Cassandra as a distributed database for use
in our server software, which runs on Windows.

This afternoon I've been trying to get Cassandra installed and running.
Actually installing Cassandra was pretty easy, at least in the steps of
"Download it, setup CASSANDRA_HOME and fiddle with the storage
configuration file", however getting it to run has not been so easy.
Admittedly, this is my first ever attempt at installing and running this
system, so I'm a sort of monkey tester here ;)

Here's a brief run-down of the issues I ran into trying out Cassandra
6.0 Beta 3, after installing Java 6 u18 and Cassandra itself (following
the instructions in http://www.mattvv.com/hosting-cassandra-on-windows/,
which may be out of date)

1. On running Cassandra, I get messages about the system not being able
to locate a path. Eventually figure out that JAVA_HOME needs to point to
a location in the [Program files]\Java folder, rather that location
itself (newbie error)
2. After configuring JAVA_HOME correctly, I get errors that the new
logging jar can't be found. I realise I skipped the 'Ant ivy-retrieve'
step in the instructions. So I download and install Ant, configure
ANT_HOME and run it.
3. I then run Ant ivy-retrieve. Oops, Tools.jar is not present. After
some Googling I determine that I need the JAVA JDK, rather than the JRE
to run it. (If this is a BETA, why does it need the JDK, surely the JRE
alone is sufficient?) I then download and install JDK 6v18 and update my
JAVA_HOME path.
4. I then run Ant ivy-retrieve again. It starts running (great), then
fails with a generic error trying to get the ivy-2.1.0.jar file. I
copied the URL into Google which promptly downloaded it, so I'm not sure
what's wrong there. I copied the ivy-2.1.0.jar file into the build
folder and tried again
5. I then run Ant ivy-retrieve again, Success (sort of). The ant job
complains it can't get the file, then notices it's there after all and
proceeds to start building. That fails horribly with many error messages
in the command window.
6. I ran it again and captured the output (attached to the email). This
explains that lots of things couldn't be resolved.

Does anyone have a step-by-step, soup to nuts, from ground zero, list of
instructions to get Cassandra installed and running on a clean windows
system?

As a suggestion, is it worth considering producing Cassandra builds that
contain all the peripheral bits and pieces it relies on (essentially
running the 'ant ivy-retrieve' command and bundling up the results as a
single download/install) so that clueless newbie users like me have a
better chance getting this running?

Thanks,
Raymond.

 


Re: Frustrations installing Cassandra on Windows

Posted by Christopher Brind <ch...@googlemail.com>.
I don't know if there's some difference between building on Mac and Windows,
but I just tried building from the latest git repo and that was fine.

I also downloaded and built the 0.6 src tar ball from
apache-cassandra-0.6.0-beta3-src.tar.gz<http://www.apache.org/dyn/closer.cgi?path=/cassandra/0.6.0/apache-cassandra-0.6.0-beta3-src.tar.gz>
 and that was fine too.

Now you know you have Java and Ant setup properly, try removing your .ivy2
folder ( C:\Users\rwilson\.ivy2 )  and just running ant (don't specify a
target).  The build script seems to do all the retrieve stuff, so you
shouldn't need to do that manually.

Cheers,
Chris



On 24 March 2010 02:49, Raymond Wilson <Ra...@trimble.co.nz> wrote:

> Hi,
>
> I've been looking at using Cassandra as a distributed database for use
> in our server software, which runs on Windows.
>
> This afternoon I've been trying to get Cassandra installed and running.
> Actually installing Cassandra was pretty easy, at least in the steps of
> "Download it, setup CASSANDRA_HOME and fiddle with the storage
> configuration file", however getting it to run has not been so easy.
> Admittedly, this is my first ever attempt at installing and running this
> system, so I'm a sort of monkey tester here ;)
>
> Here's a brief run-down of the issues I ran into trying out Cassandra
> 6.0 Beta 3, after installing Java 6 u18 and Cassandra itself (following
> the instructions in http://www.mattvv.com/hosting-cassandra-on-windows/,
> which may be out of date)
>
> 1. On running Cassandra, I get messages about the system not being able
> to locate a path. Eventually figure out that JAVA_HOME needs to point to
> a location in the [Program files]\Java folder, rather that location
> itself (newbie error)
> 2. After configuring JAVA_HOME correctly, I get errors that the new
> logging jar can't be found. I realise I skipped the 'Ant ivy-retrieve'
> step in the instructions. So I download and install Ant, configure
> ANT_HOME and run it.
> 3. I then run Ant ivy-retrieve. Oops, Tools.jar is not present. After
> some Googling I determine that I need the JAVA JDK, rather than the JRE
> to run it. (If this is a BETA, why does it need the JDK, surely the JRE
> alone is sufficient?) I then download and install JDK 6v18 and update my
> JAVA_HOME path.
> 4. I then run Ant ivy-retrieve again. It starts running (great), then
> fails with a generic error trying to get the ivy-2.1.0.jar file. I
> copied the URL into Google which promptly downloaded it, so I'm not sure
> what's wrong there. I copied the ivy-2.1.0.jar file into the build
> folder and tried again
> 5. I then run Ant ivy-retrieve again, Success (sort of). The ant job
> complains it can't get the file, then notices it's there after all and
> proceeds to start building. That fails horribly with many error messages
> in the command window.
> 6. I ran it again and captured the output (attached to the email). This
> explains that lots of things couldn't be resolved.
>
> Does anyone have a step-by-step, soup to nuts, from ground zero, list of
> instructions to get Cassandra installed and running on a clean windows
> system?
>
> As a suggestion, is it worth considering producing Cassandra builds that
> contain all the peripheral bits and pieces it relies on (essentially
> running the 'ant ivy-retrieve' command and bundling up the results as a
> single download/install) so that clueless newbie users like me have a
> better chance getting this running?
>
> Thanks,
> Raymond.
>

RE: Frustrations installing Cassandra on Windows

Posted by Raymond Wilson <Ra...@trimble.co.nz>.
Is there a target data for 0.6-final?

Raymond.

-----Original Message-----
From: Jonathan Ellis [mailto:jbellis@gmail.com] 
Sent: Wednesday, 24 March 2010 4:29 p.m.
To: user@cassandra.apache.org
Subject: Re: Frustrations installing Cassandra on Windows

On Tue, Mar 23, 2010 at 9:49 PM, Raymond Wilson
<Ra...@trimble.co.nz> wrote:
> As a suggestion, is it worth considering producing Cassandra builds
that
> contain all the peripheral bits and pieces it relies on (essentially
> running the 'ant ivy-retrieve' command and bundling up the results as
a
> single download/install) so that clueless newbie users like me have a
> better chance getting this running?

It looks like that's what we'll be doing for 0.6-final.

Maybe someone who knows ant / ivy better can explain what your ant +
ivy is smoking, sorry.

-Jonathan

Re: Frustrations installing Cassandra on Windows

Posted by Jonathan Ellis <jb...@gmail.com>.
On Tue, Mar 23, 2010 at 9:49 PM, Raymond Wilson
<Ra...@trimble.co.nz> wrote:
> As a suggestion, is it worth considering producing Cassandra builds that
> contain all the peripheral bits and pieces it relies on (essentially
> running the 'ant ivy-retrieve' command and bundling up the results as a
> single download/install) so that clueless newbie users like me have a
> better chance getting this running?

It looks like that's what we'll be doing for 0.6-final.

Maybe someone who knows ant / ivy better can explain what your ant +
ivy is smoking, sorry.

-Jonathan

Frustrations installing Cassandra on Windows

Posted by Raymond Wilson <Ra...@trimble.co.nz>.
Hi,

I've been looking at using Cassandra as a distributed database for use
in our server software, which runs on Windows.

This afternoon I've been trying to get Cassandra installed and running.
Actually installing Cassandra was pretty easy, at least in the steps of
"Download it, setup CASSANDRA_HOME and fiddle with the storage
configuration file", however getting it to run has not been so easy.
Admittedly, this is my first ever attempt at installing and running this
system, so I'm a sort of monkey tester here ;)

Here's a brief run-down of the issues I ran into trying out Cassandra
6.0 Beta 3, after installing Java 6 u18 and Cassandra itself (following
the instructions in http://www.mattvv.com/hosting-cassandra-on-windows/,
which may be out of date)

1. On running Cassandra, I get messages about the system not being able
to locate a path. Eventually figure out that JAVA_HOME needs to point to
a location in the [Program files]\Java folder, rather that location
itself (newbie error)
2. After configuring JAVA_HOME correctly, I get errors that the new
logging jar can't be found. I realise I skipped the 'Ant ivy-retrieve'
step in the instructions. So I download and install Ant, configure
ANT_HOME and run it.
3. I then run Ant ivy-retrieve. Oops, Tools.jar is not present. After
some Googling I determine that I need the JAVA JDK, rather than the JRE
to run it. (If this is a BETA, why does it need the JDK, surely the JRE
alone is sufficient?) I then download and install JDK 6v18 and update my
JAVA_HOME path.
4. I then run Ant ivy-retrieve again. It starts running (great), then
fails with a generic error trying to get the ivy-2.1.0.jar file. I
copied the URL into Google which promptly downloaded it, so I'm not sure
what's wrong there. I copied the ivy-2.1.0.jar file into the build
folder and tried again
5. I then run Ant ivy-retrieve again, Success (sort of). The ant job
complains it can't get the file, then notices it's there after all and
proceeds to start building. That fails horribly with many error messages
in the command window.
6. I ran it again and captured the output (attached to the email). This
explains that lots of things couldn't be resolved.

Does anyone have a step-by-step, soup to nuts, from ground zero, list of
instructions to get Cassandra installed and running on a clean windows
system?

As a suggestion, is it worth considering producing Cassandra builds that
contain all the peripheral bits and pieces it relies on (essentially
running the 'ant ivy-retrieve' command and bundling up the results as a
single download/install) so that clueless newbie users like me have a
better chance getting this running?

Thanks,
Raymond.

Re: Example of data model

Posted by Benjamin Black <b...@b3k.us>.
https://www.cloudkick.com/blog/2010/mar/02/4_months_with_cassandra/

On Mon, Mar 22, 2010 at 6:51 AM, Hill, Ed A <ed...@uiowa.edu> wrote:
> I've been through the twissandra data model as well and it is pretty straightforward and well explained (thanks!) - but I notice that a number of the folks using Cassandra are using it for metric collection or event processing.
>
> I wonder if someone would be willing to describe their models as a second example, particularly how they then report or query against it.
>
> Thanks!
>
> -Ed Hill (ed-hill@uiowa.edu)
> Software Developer, The University of Iowa
>
>> -----Original Message-----
>> From: Jonathan Ellis [mailto:jbellis@gmail.com]
>> Sent: Monday, March 22, 2010 8:22 AM
>> To: user@cassandra.apache.org
>> Subject: Re: Example of data model
>>
>> http://twissandra.com/
>>
>> On Mon, Mar 22, 2010 at 7:49 AM, Julio Carlos Barrera Juez
>> <ju...@gmail.com> wrote:
>> > Hi all, I need an example of cassandra storage to understand better the
>> > datamodel. I mena, an example of a little application with his
>> > storage-conf.xml file like a little commerce with a list of clients and
>> > stock.
>> > Thank's.
>

RE: Example of data model

Posted by "Hill, Ed A" <ed...@uiowa.edu>.
I've been through the twissandra data model as well and it is pretty straightforward and well explained (thanks!) - but I notice that a number of the folks using Cassandra are using it for metric collection or event processing.

I wonder if someone would be willing to describe their models as a second example, particularly how they then report or query against it.

Thanks!

-Ed Hill (ed-hill@uiowa.edu)
Software Developer, The University of Iowa
 
> -----Original Message-----
> From: Jonathan Ellis [mailto:jbellis@gmail.com]
> Sent: Monday, March 22, 2010 8:22 AM
> To: user@cassandra.apache.org
> Subject: Re: Example of data model
> 
> http://twissandra.com/
> 
> On Mon, Mar 22, 2010 at 7:49 AM, Julio Carlos Barrera Juez
> <ju...@gmail.com> wrote:
> > Hi all, I need an example of cassandra storage to understand better the
> > datamodel. I mena, an example of a little application with his
> > storage-conf.xml file like a little commerce with a list of clients and
> > stock.
> > Thank's.

Re: Example of data model

Posted by Jonathan Ellis <jb...@gmail.com>.
http://twissandra.com/

On Mon, Mar 22, 2010 at 7:49 AM, Julio Carlos Barrera Juez
<ju...@gmail.com> wrote:
> Hi all, I need an example of cassandra storage to understand better the
> datamodel. I mena, an example of a little application with his
> storage-conf.xml file like a little commerce with a list of clients and
> stock.
> Thank's.

Re: Example of data model

Posted by TeĆ³filo Ruiz <te...@gmail.com>.
Hi,

On Mon, Mar 22, 2010 at 13:49, Julio Carlos Barrera Juez
<ju...@gmail.com> wrote:
> Hi all, I need an example of cassandra storage to understand better the
> datamodel. I mena, an example of a little application with his
> storage-conf.xml file like a little commerce with a list of clients and
> stock.

You should probably read this:
<http://blog.evanweaver.com/articles/2009/07/06/up-and-running-with-cassandra/>,
a comprehensive explanation of different Cassandra datamodels.

Enjoy.
-- 
teo - http://www.teoruiz.com

"Res publica non dominetur"