Cassandra 1.x and proper JNA setup

2011-11-01 Thread Maciej Miklas
Hi all, is there any documentation about proper JNA configuration? I do not understand few things: 1) Does JNA use JVM heap settings? 2) Do I need to decrease max heap size while using JNA? 3) How do I limit RAM allocated by JNA? 4) Where can I see / monitor row cache size? 5) I've configure

Re: Cassandra Cluster Admin - phpMyAdmin for Cassandra

2011-11-01 Thread Aditya Narayan
Yes that would be pretty nice feature to see! On Mon, Oct 31, 2011 at 10:45 PM, Ertio Lew wrote: > Thanks so much SebWajam for this great piece of work! > > Is there a way to set a data type for displaying the column names/ values > of a CF ? It seems that your project always uses String Seri

Cassandra properties

2011-11-01 Thread Lewis John Mcgibbney
Hi Cassandra users, I've begun work on a very exciting project which has been moving quite slowly recently. It's combining Apache Nutch, Gora ORM framework (Apache Incubator) and Apache Cassandra as a back end storage platform for web crawling. Atm I'm running Cassandra 0.8.4 in local/single mode

Re: data model for unique users in a time period

2011-11-01 Thread Daniel Doubleday
Hm - kind of hijacking this but since we have a similar problem I might throw in my idea: We need consistent, idempotent counters. On the client side we can create unique (replayable) keys - like your user ids. What we want to do is: - add increment commands as columns such as [prefixByte.uniq

Storing and querying IP ranges in Cassandra

2011-11-01 Thread Tamas Marki
Hello, I'm new to the list and also to Cassandra. I found it when I was searching for something to replace our busy mysql server. One of the things we use the server for is filtering IPs based on a list of IP ranges. These ranges can be small and big, and there are about 50k of them in the databa

Re: Storing and querying IP ranges in Cassandra

2011-11-01 Thread Zach Richardson
How many total ranges to you expect to have long term? On Tue, Nov 1, 2011 at 11:17 AM, Tamas Marki wrote: > Hello, > > I'm new to the list and also to Cassandra. I found it when I was searching > for something to replace our busy mysql server. > > One of the things we use the server for is filte

Re: Storing and querying IP ranges in Cassandra

2011-11-01 Thread Tamas Marki
It's unpredictable, there could be hundreds of thousands, even millions (but unlikely). Tamas On Tue, Nov 1, 2011 at 5:38 PM, Zach Richardson wrote: > How many total ranges to you expect to have long term? > > On Tue, Nov 1, 2011 at 11:17 AM, Tamas Marki wrote: > > Hello, > > > > I'm new to th

Re: Storing and querying IP ranges in Cassandra

2011-11-01 Thread Brandon Williams
On Tue, Nov 1, 2011 at 11:17 AM, Tamas Marki wrote: > Hello, > > I'm new to the list and also to Cassandra. I found it when I was searching > for something to replace our busy mysql server. > > One of the things we use the server for is filtering IPs based on a list of > IP ranges. These ranges ca

Re: Tool for SQL -> Cassandra data movement

2011-11-01 Thread Maxim Potekhin
Just a short comment -- we are going the CSV way as well because of its compactness and extreme portability. The CSV files are kept in the cloud as backup. They can also find other uses. JSON would work as well, but it would be at least twice as large in size. Maxim On 9/22/2011 1:25 PM, Nehal

Re: Storing and querying IP ranges in Cassandra

2011-11-01 Thread Aaron Turner
On Tue, Nov 1, 2011 at 9:17 AM, Tamas Marki wrote: > Hello, > > I'm new to the list and also to Cassandra. I found it when I was searching > for something to replace our busy mysql server. > > One of the things we use the server for is filtering IPs based on a list of > IP ranges. These ranges can

Commit log grows and grows

2011-11-01 Thread Fredrik Stigbäck
I have a problem or at least something that I have missed to understand regarding commit log removal. I'm running cassandra 1.0.1 but have seen the same "thing" in 1.0. I thought that when a node is flushed or drained, it's memtable is flushed to disk and the commit log is removed and new commit lo

Re: Commit log grows and grows

2011-11-01 Thread Jonathan Ellis
"hasnext false" means "this is the last commitlog segment, so we'll keep it around to add new entries too until it fills up at 128MB. On Tue, Nov 1, 2011 at 3:06 PM, Fredrik Stigbäck wrote: > I have a problem or at least something that I have missed to > understand regarding commit log removal. >

R on Cassandra

2011-11-01 Thread Brian O'Neill
I saw a mention of R on Cassandra: http://comments.gmane.org/gmane.comp.db.cassandra.user/5681 Does anyone know if this has traction somewhere? -brian -- Brian ONeill Lead Architect, Health Market Science (http://healthmarketscience.com) mobile:215.588.6024 blog: http://weblogs.java.net/blog/bo

Rename a column family on 1.0.x

2011-11-01 Thread Todd Fast
Any advice for renaming a column family in version 1.0.x? Like most of the docs, the FAQ (http://wiki.apache.org/cassandra/FAQ#modify_cf_config) is out of date. Todd

Problem SliceByNamesReadCommand on super column family after flush operation

2011-11-01 Thread Mike Smith
Hi, I'm having a problem with doing a multiget_slice on a super column family after its first flush. Updates to the column values work properly, but trying to retrieve the updated values using a multiget_slice operation fail to get the updated values. Instead they return the values from before the

Re: AssertionError Exception on cassandra 1.0.1

2011-11-01 Thread Jonathan Ellis
Looks like a bug. I've created https://issues.apache.org/jira/browse/CASSANDRA-3440. On Tue, Nov 1, 2011 at 5:50 PM, Ramesh Natarajan wrote: > We have a 8 node cassandra cluster running 1.0.1. After running a load > test for a day we are seeing this exception in system.log file. At > this time w

Re: Problem SliceByNamesReadCommand on super column family after flush operation

2011-11-01 Thread Jonathan Ellis
Can you file a Jira ticket? And, can you reproduce using normal columns? On Tue, Nov 1, 2011 at 7:06 PM, Mike Smith wrote: > Hi, > I'm having a problem with doing a multiget_slice on a super column family > after its first flush. Updates to the column values work properly, but > trying to retrie

cassandra error (compaction)

2011-11-01 Thread the-bad
ERROR [CompactionExecutor:655] 2011-11-01 20:11:12,652 AbstractCassandraDaemon.java (line 139) Fatal exception in thread Thread[CompactionExecutor:655,1,main] java.io.IOError: java.io.EOFException at org.apache.cassandra.io.util.ColumnIterator.deserializeNext(ColumnSortedMap.java :265)

Re: Internal error processing get: Null pointer exception

2011-11-01 Thread Jonathan Ellis
That doesn't make sense to me. CS:147 is columnFamilyKeyMap.put(row.key, row.cf); where cFKM is Map columnFamilyKeyMap = new HashMap(); So cFKM can't be null, and HashMap accomodates both null key and null value, so I'm not sure what there is to thorw NPE. On Tue, Nov 1, 2

Re: Second Cassandra users survey

2011-11-01 Thread Ramesh Natarajan
Here is my wish list - I would love Cassandra to - provide a efficient method to retrieve the count of columns for a given row without resorting to read all columns and calculate the count for a given row key. - support auto increment column names - Column slice based query doesn't take advant