Similar to https://issues.apache.org/jira/browse/CASSANDRA-3054
can you create a new ticket and link to that one. ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 24/08/2011, at 10:33 PM, Renato Bacelar da Silveira wrote: > 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 >
