cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Renato Bacelar da Silveira <>
Subject Cassandra-CLI does not allow list 1105115; with Syntax error
Date Wed, 24 Aug 2011 10:33:23 GMT
Just some information about the Column family in question:

     ColumnFamily: 1105100
       Key Validation Class: org.apache.cassandra.db.marshal.BytesType
       Default column value validator: 
       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 

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

which confirmed that perhaps I should change the ColumFamily name?


-------- 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 <>
To: 	user@cass <>

  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

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

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.

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

Renato da Silveira
Senior Developer

View raw message