incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From aaron morton <aa...@thelastpickle.com>
Subject Re: Cassandra-CLI does not allow list 1105115; with Syntax error
Date Wed, 24 Aug 2011 21:09:56 GMT
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 <renatods@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
> 


Mime
View raw message