RE: Added column does not sort as the last column at

2013-05-14 Thread Sam Hodgson
Morton > Freelance Cassandra Consultant > New Zealand > > @aaronmorton > http://www.thelastpickle.com > > On 10/04/2013, at 1:26 AM, Sam Hodgson wrote: > > > Hi All, > > > > > > > > I just upgraded from Cassandra 1.1.7 to 1.2

Added column does not sort as the last column at

2013-04-09 Thread Sam Hodgson
Hi All, I just upgraded from Cassandra 1.1.7 to 1.2.3 and im now seeing a lot of the following error in my output.log, cant find much on the web about it: ERROR 11:56:01,317 Exception in thread Thread[ReadStage:7236,5,main] java.lang.AssertionError: Added column does not sort as the last column a

RE: Pagination

2012-11-27 Thread Sam Hodgson
, Nov 27, 2012 at 12:19 PM, Sam Hodgson wrote: Hi All, Wondering if anyone has any good solutions to pagination? In particular enumerating the number of pages and linking to each page, a common feature in forums. This code is untested (using phpcassa) and may need tweaking to get the

RE: Secondary Index Validation Type Parse Error

2012-03-18 Thread Sam Hodgson
Hi me again - sorry i've just read that bytestype will expect hex input so my question now is how to create a column that will accept non-validated text as as input? I think I can maybe get round this by forcing UTF8Encoding regardless if the string is already identified as UTF8 or not however

Secondary Index Validation Type Parse Error

2012-03-18 Thread Sam Hodgson
Hi All, Getting the following parse error when trying to create a CF with a secondary index using the bytestype attribute, the index is for a column called 'subject': java.lang.RuntimeException: org.apache.cassandra.db.marshal.MarshalException: cannot parse 'subject' as hex bytes Im doing all

Previous Page Pagination?

2011-10-29 Thread Sam Hodgson
Hi, Is there a good method to use for pagination in Cassandra? I can create a next page link by pulling an extra column when getting however previous page is proving tricky. Im using integer timestamps as column keys so would really need a way to pull out the 10 preceeding columns as well as

Updates Question

2011-10-24 Thread Sam Hodgson
Hi, Im currently experimenting with Cassandra on a single node using phpcassa and im having issues when trying to update data in existing columns. I can write new columns/rows etc no problem however when updating I get no errors back and the update does not occur. I've also tried updating ma

RE: SCF column comparator

2011-09-27 Thread Sam Hodgson
Aaron MortonFreelance Cassandra Developer@aaronmortonhttp://www.thelastpickle.com On 27/09/2011, at 3:46 AM, Sam Hodgson wrote:Hi all, Im trying to create a Threads SCF that will store message thread id's in date order and i want to store the threadID => subject as the supercolumns. Please cor

SCF column comparator

2011-09-26 Thread Sam Hodgson
Hi all, Im trying to create a Threads SCF that will store message thread id's in date order and i want to store the threadID => subject as the supercolumns. Please correct me if im incorrect but my understanding of a super column family is as follows: Category: //row key Timestamp: //Colu