cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Renato Bacelar da Silveira <renat...@indabamobile.co.za>
Subject Re: Cassandra-CLI does not allow list 1105115; with Syntax error
Date Thu, 25 Aug 2011 08:21:05 GMT
Issue created at

https://issues.apache.org/jira/browse/CASSANDRA-3075


Thanks Again Aaron

On 24/08/2011 23:09, aaron morton wrote:
> 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