Re: Efficient IP address location lookup

2013-11-15 Thread Jacob Rhoden
> On 16 Nov 2013, at 1:47 pm, Jon Haddad wrote: > Instead of determining your table first, you should figure out what you want > to ask Cassandra. Thanks Jon, Perhaps I should have been more clear. I need to efficiently look up the location of an IP address. >> On Nov 15, 2013, at 4:36 PM, Ja

Re: Efficient IP address location lookup

2013-11-15 Thread Jon Haddad
Instead of determining your table first, you should figure out what you want to ask Cassandra. What do you want to look up your data by? For each query you may need to store the data multiple times, which is perfectly reasonable and is recommended. On Nov 15, 2013, at 4:36 PM, Jacob Rhoden wr

Efficient IP address location lookup

2013-11-15 Thread Jacob Rhoden
Hi Guys, It occurs to me that someone may have done this before and be willing to share, or may just be interested in helping work out it. Assuming a database table where the partition key is the first component of a users IPv4 address, i.e. (ip=100.0.0.1, part=100) and the remaining three part

Re: java.io.FileNotFoundException when setting up internode_compression

2013-11-15 Thread Jan Schmidle
I had this error as well some time ago. It was due to the noexec mount flag of the tmp directory. Worked again when I removed that flag from the tmp directory. Cheers -- Jan Schmidle Founder & CEO P+49 89 999540-41 mschmi...@cospired.com cospired GmbH Roßmarkt 6 D-80331 Munich P+49 89 999540

Re: Insert with if-not-exists does not persist map

2013-11-15 Thread Mohica Jasha
I have been testing against C* 2.0.1. It turned out that the bug is resolved in C* 2.0.2. On Fri, Nov 15, 2013 at 12:57 PM, Robert Coli wrote: > On Fri, Nov 15, 2013 at 7:10 AM, Mohica Jasha wrote: > >> Cassandra 2.0.2 does not persist the map collection when I specify an >> if-not-exists cla

Re: Insert with if-not-exists does not persist map

2013-11-15 Thread Robert Coli
On Fri, Nov 15, 2013 at 7:10 AM, Mohica Jasha wrote: > Cassandra 2.0.2 does not persist the map collection when I specify an > if-not-exists clause in the insert operation: > > cqlsh:mohica>CREATE TABLE simple (id1 TEXT, ,my_map MAP TEXT>,PRIMARY KEY (id1)); > cqlsh:mohica>INSERT INTO simple(id1,m

Insert with if-not-exists does not persist map

2013-11-15 Thread Mohica Jasha
Cassandra 2.0.2 does not persist the map collection when I specify an if-not-exists clause in the insert operation: cqlsh:mohica>CREATE TABLE simple (id1 TEXT, ,my_map MAP,PRIMARY KEY (id1)); cqlsh:mohica>INSERT INTO simple(id1,my_map) VALUES ('id1',{'a1':'b1','a2':'b1'}) if not exists; [applied

Error: Unable to search across multiple secondary index types

2013-11-15 Thread sielski
Hello, I’ve installed Cassandra 2.0.2 and I’m trying to query a cassandra table using a SELECT statement with two WHERE clauses on columns with secondary indexes but Cassandra throws an error as in the subject. It’s easy to reproduce this problem. My table structure is as follows: CREATE TABLE t