sorting with sstableloader

[varun allampalli <vs...@gmail.com>]

Hi,

I have a table with schema

CREATE TABLE TEST_TABLE (

  keyCol bigint,

  col1 bigint,

  col2 bigint,

  col3 text,

 ) WITH CLUSTERING ORDER BY (col1 DESC, col2 DESC)

on cassandra 1.2.13


I used SSTableSimpleUnsortedWriter and sstableloader to load some data and
loaded data for a keycolumn keyCol1

select * from test_table returned

 keyCol         col1     col2        col3

keyCol1        10        1          abcde

keyCol1         9         1          adfsa


I again created some sstables and loaded using sstableloader which has
records for keyCol1, but with col1 value as 20 which is

keyCol         col1     col2        col3

keyCol1        20         1           afd

So when I queried select * from test_table I was expecting

keyCol1        20         1           afd
keyCol1        10        1          abcde

keyCol1         9         1          adfsa


but it returned
keyCol1        10        1          abcde

keyCol1         9         1          adfsa

keyCol1        20         1           afd
How to fix this sorting, the col1 of value 20 was inserted later using
sstableloader so it is showing up as the last row.

Is there anyway to rewrite sstables to fix this sorting, or do I need to
run anything after running sstable loader to fix this sorting.

Thanks
Varun