I am using casandra 1.1.3 and OpsCenter v2.1.2.
My Problem: I created a table with the following cql 3 statement:
CREATE TABLE test_metadata (id uuid, url text, publicationTime timestamp, PRIMARY KEY(id, url))
Note the double Primary Key.
After this I inserted test data:
INSERT INTO test_metadata (id, url, publicationTime) VALUES ( '139fc480-1dd2-11b2-0000-71c6873e1ff7', 'http://example.com', 1345109752000)
If I now try to view the data in the OpsCenter data explorer, I get the error message "Error loading data: 'utf8' codec can't decode byte 0x9c in position 5: invalid start byte".
So it seems OpsCenter tries to interpret the timestamp as UTF8 value. My guess is, it uses the default Validator for the column family. From what I understand, specifying a primary key with more than one column in cql 3 means under the hood composite columns are used. Is it possible that OpsCenter has Problems with composite columns?