Different comparator types for column and supercolumn don't work

[Karin Kirsch]

Hello,

I'm new to cassandra. I'm using cassandra release 0.7.0 (local, single node). I 
can't perform write operations in case the column and supercolumn families have
different comparator types. For example if I use the code given in Issue: 
https://issues.apache.org/jira/browse/CASSANDRA-1712 by Jonathan Ellis in the 
CLI, I get the following output:

[default@Keyspace1] create keyspace KS1
8bb2fc2d-1fcb-11e0-add0-a9c93d38c544
[default@Keyspace1] use KS1
Authenticated to keyspace: KS1
[default@KS1] create column family CFCli with column_type= 'Super' and 
comparator= 'LongType' and subcomparator='UTF8Type'
97742bbe-1fcb-11e0-add0-a9c93d38c544
[default@KS1] set CFCli['newrow'][1234567890]['column'] = 'value'
'column' could not be translated into a LongType.

I also tried a setup with the release inclosed example keyspace (loaded via the 
StorageService bean loadSchemaFromYAML method):

   ColumnFamily: Super3 (Super)
   "A column family with supercolumns, whose column names are Longs (8 bytes)"
     Columns sorted by: 
org.apache.cassandra.db.marshal.LongType/org.apache.cassandra.db.marshal.BytesType
     Subcolumns sorted by: org.apache.cassandra.db.marshal.LongType
     Row cache size / save period: 0.0/0
     Key cache size / save period: 200000.0/3600
     Memtable thresholds: 0.2953125/63/60
     GC grace seconds: 864000
     Compaction min/max thresholds: 4/32

CLI output:

[default@Keyspace1] set Super3['account_value']['1:1'][1234567890] = 'value1'   
                             
A long is exactly 8 bytes: 3
[default@Keyspace1] set Super3['account_value'][1234567890]['test'] = 'value1'
'test' could not be translated into a LongType.
[default@Keyspace1] set Super3['account_value'][1234567890][1234567890] = 
'value1'
A long is exactly 8 bytes: 10
[default@Keyspace1] set Super3[1234567890][1234567890][1234567890] = 'value1' 
Syntax error at position 11: mismatched input '1234567890' expecting set null
[default@Keyspace1] set Super3['account_value']['test'][1234567890] = 'value1'
A long is exactly 8 bytes: 4
[default@Keyspace1] set Super3[1234567890]['test']['column'] = 'value1'       
Syntax error at position 11: mismatched input '1234567890' expecting set null


According to the CLI help the format is: set <cf>['<key>']['<super>']['<col>'] 
= <value>, thus the errors generated seem weird for me. What am I doing wrong?


Thanks in advance,

Kind regards,

Karin