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

2013-05-14 Thread Sam Hodgson
://www.thelastpickle.com On 10/04/2013, at 1:26 AM, Sam Hodgson hodgson_...@hotmail.com wrote: 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

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

RE: Pagination

2012-11-27 Thread Sam Hodgson
, Nov 27, 2012 at 12:19 PM, Sam Hodgson hodgson_...@hotmail.com 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

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

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

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

RE: SCF column comparator

2011-09-27 Thread Sam Hodgson
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 correct me if im

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: