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 <[email protected]>
Reply-To: [email protected]
To: user@cass <[email protected]>
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
