Re: How would you model that?

2013-11-12 Thread Aaron Morton
> Hey guys, I need to retrieve a list of distinct users based on their activity > datetime. How can I model a table to store that kind of information? If it’s for an arbitrary time slice it will be tricky, if you can use pre set time slices something like this would work: CREATE TABLE (

Re: Duplicate hard link - Cassandra 1.2.9

2013-11-12 Thread Robert Coli
On Mon, Nov 11, 2013 at 8:06 PM, Aaron Morton wrote: > If you can reproduce it may be time to raise a ticket including the JBOD > setup https://issues.apache.org/jira/browse/CASSANDRA > Per OP on https://issues.apache.org/jira/browse/CASSANDRA-6298 " As it turns out, I was using symlinks. I had m

Re: Cassandra debian package that supports ver. 1.11.11

2013-11-12 Thread Blair Zajac
On 11/12/2013 12:23 PM, Michael Hayes wrote: I need this specific version for my usergrid chef recipe. Right now I’m using the datastax tarball from: http://downloads.datastax.com/community/dsc-cassandra-1.1.11-bin.tar.gz But a debian package would be better to properly setup the node. http:/

Cassandra debian package that supports ver. 1.11.11

2013-11-12 Thread Michael Hayes
I need this specific version for my usergrid chef recipe. Right now I’m using the datastax tarball from: http://downloads.datastax.com/community/dsc-cassandra-1.1.11-bin.tar.gz But a debian package would be better to properly setup the node. Any suggestions appreciated. Thanks.

Re: CF backup / restore selected columns

2013-11-12 Thread Tyler Hobbs
There's no easy way to do this that I'm aware of. Snapshots are just hardlinks to existing SSTable files. Your best option is probably either scanning the CF with a normal client or setting up an M/R job. On Mon, Nov 11, 2013 at 5:06 PM, Turi, Ferenc (GE Power & Water, Non-GE) < ferenc.t...@ge.

Re: Statistics

2013-11-12 Thread Tyler Hobbs
This may be an easier method: http://www.datastax.com/dev/blog/pluggable-metrics-reporting-in-cassandra-2-0-2 On Fri, Nov 8, 2013 at 3:57 PM, David Chia wrote: > http://www.datastax.com/dev/blog/metrics-in-cassandra12 > > > On Fri, Nov 8, 2013 at 11:42 AM, Parag Patel wrote: > >>Hi, >> >> >

Re: rcp timeout after using sstableloader

2013-11-12 Thread Tyler Hobbs
You might be seeing https://issues.apache.org/jira/browse/CASSANDRA-6272, depending on what version of Cassandra you're running. On Tue, Nov 12, 2013 at 1:34 AM, Turi, Ferenc (GE Power & Water, Non-GE) < ferenc.t...@ge.com> wrote: > Hi, > > > > I tried to get experience in creating sstable usin

Re: java.io.FileNotFoundException when setting up internode_compression

2013-11-12 Thread srmore
Thanks Christopher ! I don't think glibc is an issue (as it did go that far) /usr/tmp/ snappy-1.0.5-libsnappyjava.so is not there, permissions look ok, are there any special settings (like JVM args) that I should be using ? I can see libsnappyjava.so in the jar though (snappy-java-1.0.5.jar\org\xer

Re: Cass 2.0.0: Extensive memory allocation when row_cache enabled

2013-11-12 Thread Jiri Horky
Hi, On 11/12/2013 05:29 AM, Aaron Morton wrote: >>> Are you doing large slices or do could you have a lot of tombstones >>> on the rows ? >> don't really know - how can I monitor that? > For tombstones, do you do a lot of deletes ? > Also in v2.0.2 cfstats has this > > Average live cells per sli

Modeling multi-tenanted Cassandra schema

2013-11-12 Thread Ben Hood
Hi, I've just received a requirement to make a Cassandra app multi-tenanted, where we'll have up to 100 tenants. Most of the tables are timestamped wide row tables with a natural application key for the partitioning key and a timestamp key as a cluster key. So I was considering the options: (a)

答复: How to configure linux service for Cassandra?

2013-11-12 Thread Boole.Z.Guo (mis.cnsh04.Newegg) 41442
Thanks very much. I will try. The goal of ccm and ccmlib is to make is easy to create, manage and destroy a small cluster on a local box. It is meant for testing of a Cassandra cluster. Best Regards, Boole Guo Software Engineer, NESC-SH.MIS +86-021-51530666*41442 Floor 19, KaiKai Plaza, 888, Wanha

RE: How to configure linux service for Cassandra?

2013-11-12 Thread Christopher Wirt
Starting multiple Cassandra nodes on the same machine involves setting loop back aliases and some configuration fiddling. Lucky for you Sylvain Lebresne made this handy tool in python which does the job for you. https://github.com/pcmanus/ccm to run as a service you need a script like thi