Cassandra-CLI does not allow list 1105115; with Syntax error

[Renato Bacelar da Silveira]

Just some information about the Column family in question:
    ColumnFamily: 1105100
      Key Validation Class: org.apache.cassandra.db.marshal.BytesType
      Default column value validator: 
org.apache.cassandra.db.marshal.BytesType
      Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
      Row cache size / save period in seconds: 0.0/0
      Key cache size / save period in seconds: 200000.0/14400
      Memtable thresholds: 0.5203125/111/1440 (millions of ops/MB/minutes)
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Replicate on write: true
      Built indexes: []

I do observe that the Key Validation is BytesType, so I also tried 
(giddily)

[default@unknown] list bytes(1105100);
Syntax error at position 10: missing EOF at '('

which confirmed that perhaps I should change the ColumFamily name?

Regards.

-------- Original Message --------
Subject:        Cassandra-CLI does not allow list 1105115; with Syntax error
Date:   Wed, 24 Aug 2011 12:11:09 +0200
From:   Renato Bacelar da Silveira <renat...@indabamobile.co.za>
Reply-To:       user@cassandra.apache.org
To:     user@cass <user@cassandra.apache.org>



 Hi All

Good day,

A question concerning Cassandra-Cli.

I have a Column Family named 11001500.

I have inserted the CF with Hector, and it did not
throw any exception concerning the name of the
column.

If I am issuing the command

list 1105115;

I incur the following error:

[default@unknown] list 1105115;
Syntax error at position 5: mismatched input '1105115' expecting Identifier
*
I presume we are not to name CFs as integers?*

 Or is there something I am missing from
the bellow help content:

[default@unknown] help list;
list <cf>;
list <cf>[<startKey>:];
list <cf>[<startKey>:<endKey>];
list <cf>[<startKey>:<endKey>] limit <limit>;

List a range of rows, and all of their columns, in the specified column
family.

The order of rows returned is dependant on the Partitioner in use.

Required Parameters:
- cf: Name of the column family to list rows from.

Optional Parameters:
- endKey: Key to end the range at. The end key will be included
in the result. Defaults to an empty byte array.

- limit: Number of rows to return. Default is 100.

- startKey: Key start the range from. The start key will be
included in the result. Defaults to an empty byte array.

Examples:
list Standard1;
list Super1[j:];
list Standard1[j:k] limit 40;



Renato da Silveira
Senior Developer
www.indabamobile.co.za