Re: supervisord and cassandra

2014-02-13 Thread Tristan Seligmann
On 14 February 2014 03:03, David Montgomery wrote: > I only added the -f flag after the first time it did not work. If I dont > use the -f flag. > > cassandra_server:cassandra FATAL Exited too quickly (process log > may have details) Whoops, I got mixed up; the -f param to Cassand

Re: supervisord and cassandra

2014-02-13 Thread Tristan Seligmann
On 13 February 2014 11:39, David Montgomery wrote: > [program:cassandra] > command = /var/apache-cassandra-<%=@version%>/bin/cassandra -f I'm not familiar with supervisor specifically, but most process supervisors want the supervised process not to fork; that is, remove the -f from the command he

Re: BigTable-like Versioned Cells, Importing PostgreSQL Data

2013-09-29 Thread Tristan Seligmann
I saw nobody has responded to this so I thought I'd take a shot. On Fri, Sep 20, 2013 at 6:13 AM, Keith Bogs wrote: > > Key 1379649588:body 1379649522:body 1379649123:title > a.com/1.html """A" > a.com/2.html """B" > b.com/1.html ""

Re: IllegalArgumentException on query with AbstractCompositeType

2013-07-14 Thread Tristan Seligmann
On Mon, Jul 15, 2013 at 12:26 AM, aaron morton wrote: > Aaron Morton can confirm but I think one problem could be that to create > an index on a field with small number of possible values is not good. > > Yes. > In cassandra each value in the index becomes a single row in the internal > secondary

Re: IllegalArgumentException on query with AbstractCompositeType

2013-07-13 Thread Tristan Seligmann
On Fri, Jul 12, 2013 at 10:38 AM, aaron morton wrote: > CREATE INDEX ON conv_msgdata_by_participant_cql(msgReadFlag); > > On general this is a bad idea in Cassandra (also in a relational DB IMHO). > You will get poor performance from it. > Could you elaborate on why this is a bad idea? -- mi

Re: Representation of dynamically added columns in table (column family) schema using cqlsh

2013-07-13 Thread Tristan Seligmann
See http://www.datastax.com/dev/blog/thrift-to-cql3 for more information. On Sat, Jul 13, 2013 at 1:19 AM, Eric Stevens wrote: > If you're creating dynamic columns via Thrift interface, they will not be > reflected in the CQL3 schema. I would recommend not mixing paradigms like > that, either

Re: Using CQL to insert a column to a row dynamically

2013-05-28 Thread Tristan Seligmann
On Mon, May 27, 2013 at 11:38 PM, Matthew Hillsborough < matthew.hillsboro...@gmail.com> wrote: > Originally what I thought of doing was creating a column family in > Cassandra named `ride_events`. Each row key would be a rideID that's simply > an integer. I would then arbitrarily create columns w

Re: -pr vs. no -pr

2013-03-01 Thread Tristan Seligmann
On Fri, Mar 1, 2013 at 12:39 AM, Hiller, Dean wrote: > Isn't it true if I have 6 nodes, I could run nodetool repair on just 2 > nodes(RF=3) instead of using nodetool repair –pr??? > > What is the advantage of –pr then? I think the main advantage of nodetool is that you don't have to calculate /

Re: NULL values

2013-02-27 Thread Tristan Seligmann
Cassandra only stores keys, not columns; once all of the columns in a row have been deleted, there is nothing left to delete, although the row may still appear in some queries (with no columns) until the tombstones for those columns have been removed (which occurs during compaction once gc_grace_se

Re: Cassandra 1.2

2013-01-07 Thread Tristan Seligmann
If you use PRIMARY KEY ((a, b)) instead of PRIMARY KEY (a, b), the partition key will be a composite of both the a and b values; with PRIMARY KEY (a, b), the partition key will be a, and the column names will be a composite of b and the column name (c being the only regular column here). I am gues

Re: CQL3 Compound Primary Keys - Do I have the right idea?

2012-12-23 Thread Tristan Seligmann
On Sun, Dec 23, 2012 at 9:25 PM, aaron morton wrote: > In this example: > > CREATE TABLE seen_ships ( >day text, >time_seen timestamp, >shipname text, >PRIMARY KEY (day, time_seen) >); > http://www.datastax.com/dev/blog/whats-new-in-cql-3-0 > > * day is the int

Re: Replication Factor and Consistency Level Confusion

2012-12-20 Thread Tristan Seligmann
On Thu, Dec 20, 2012 at 11:26 AM, Vasileios Vlachos wrote: > Initially we were thinking the same thing, that an explanation would > be that the "wrong" node could be down, but then isn't this something > that hinted handoff sorts out? If a node is partitioned from the rest of the cluster (ie. the

Re: Service killed by signal 9

2012-11-07 Thread Tristan Seligmann
On Wed, Nov 7, 2012 at 9:46 PM, Marcelo Elias Del Valle wrote: > Service killed by signal 9 Signal 9 is SIGKILL. Assuming that you're not killing the process yourself, I guess the most likely cause of this is the OOM killer. If you check /var/log/kern.log or dmesg you should see a message confirm

Re: Create CF with composite column through CQL 3

2012-10-31 Thread Tristan Seligmann
On Wed, Oct 31, 2012 at 7:14 PM, Wei Zhu wrote: > I try to use CQL3 to create CF with composite columns, > > CREATE TABLE Friends ( > ... user_id bigint, > ... friend_id bigint, > ... status int, > ... source int, > ... created time

Re: Number of columns per row for Composite Primary Key CQL 3.0

2012-09-12 Thread Tristan Seligmann
On Wed, Sep 12, 2012 at 11:42 PM, aaron morton wrote: > > What is "MM" stands for? million ? > > Yup. > > No idea why I do that. I should note that some people use "1MM" to indicate "1 million milion" ie. 1 billion, so this might be doubly confusing for some ;) -- mithrandi, i Ainil en-Balandor,

Re: Thrift version and OOM errors

2012-07-04 Thread Tristan Seligmann
On Jul 4, 2012 2:02 PM, "Vasileios Vlachos" wrote: > > Any ideas what could be causing strange message lengths? One cause of this that I've seen is a client using unframed Thrift transport while the server expects framed, or vice versa. I suppose a similar cause could be something that is not a T

Re: Playing around with Cassandra ... how did the value changed?

2012-01-22 Thread Tristan Seligmann
On Sun, Jan 22, 2012 at 10:11 AM, Eric Czech wrote: > That's likely because there wasn't previously a validation class for the > "age" column before you added that index.  In other words, the CLI doesn't > display values in a UTF8 format until you tell it to so I think the value > "8" is correct a

Re: Storing (python) objects

2011-09-23 Thread Tristan Seligmann
On Fri, Sep 23, 2011 at 1:09 AM, Alexis Lê-Quôc wrote: > For data accessed through a single path, I use the same trick: pickle, bz2 > and insert. Note that unpickling a pickle in Python involves a) arbitrary code execution, and b) relies on your code being the same (or close enough) to what it wa

Re: Snapshot Memory Allocation Error

2011-08-10 Thread Tristan Seligmann
On Wed, Aug 10, 2011 at 3:49 PM, earltbj wrote: > Any idea what could be causing this? See https://wiki.apache.org/cassandra/FAQ#jna -- mithrandi, i Ainil en-Balandor, a faer Ambar

Help with schema modelling

2011-07-16 Thread Tristan Seligmann
I'm trying to model a schema for a logging storage system in Cassandra: Log messages consist of a timestamp, message, and some other arbitrary key/value pairs. Querying would primarily be done based on timestamp ranges; I will probably be doing filtering based on matches against the key/value pairs

Re: Ran into an issue where Cassandra Crashed when running out of heap space

2010-07-20 Thread Tristan Seligmann
On Tue, Jul 20, 2010 at 9:09 PM, Peter Schuller wrote: >> CassandraDaemon.java (line 83) Uncaught exception in thread >> Thread[pool-1-thread-37895,5,main] >> java.lang.OutOfMemoryError: Java heap space >>     at >> org.apache.thrift.protocol.TBinaryProtocol.readStringBody(TBinaryProtocol.jav