RE: Problem using sstableloader with SSTableSimpleUnsortedWriter and a composite key

2013-06-30 Thread Peer, Oded
Thank you Aaaron! Your blog post helped me understand how a row with a compound key is stored and this helped me understand how to create the sstable files. For anyone who needs it this is how it works: In Cassandra-cli the row looks like this: RowKey: 5 => (column=10:created, value=013f84be

Re: Problem using sstableloader with SSTableSimpleUnsortedWriter and a composite key

2013-06-27 Thread aaron morton
> create table test_table ( k1 bigint, k2 bigint, created timestamp, PRIMARY > KEY (k1, k2) ) with compaction = { 'class' : 'LeveledCompactionStrategy' }; When CQL creates a non COMPACT STORAGE (http://www.datastax.com/docs/1.2/cql_cli/cql/CREATE_TABLE#using-compact-storage) table it uses comp

Problem using sstableloader with SSTableSimpleUnsortedWriter and a composite key

2013-06-27 Thread Peer, Oded
Hi, I am using Cassandra 1.2.5. I built a cluster of 2 data centers with 3 nodes in each data center. I created a key space and table with a composite key: create keyspace test_keyspace WITH replication = {'class': 'NetworkTopologyStrategy', 'DC1' : 1, 'DC2' : 1}; create table test_table (