Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 456708A1A for ; Wed, 24 Aug 2011 10:12:04 +0000 (UTC) Received: (qmail 80609 invoked by uid 500); 24 Aug 2011 10:12:01 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 80289 invoked by uid 500); 24 Aug 2011 10:11:50 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 80237 invoked by uid 99); 24 Aug 2011 10:11:42 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2011 10:11:42 +0000 X-ASF-Spam-Status: No, hits=4.6 required=5.0 tests=FROM_12LTRDOM,HTML_MESSAGE,SPF_NEUTRAL,T_FRT_BELOW2 X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [196.33.12.32] (HELO awaks.indabamobile.co.za) (196.33.12.32) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2011 10:11:36 +0000 Received: from localhost (localhost [127.0.0.1]) by awaks.indabamobile.co.za (Postfix) with ESMTP id 17E4C881C4E for ; Wed, 24 Aug 2011 12:11:11 +0200 (SAST) X-Virus-Scanned: Debian amavisd-new at awaks.indabamobile.co.za Received: from awaks.indabamobile.co.za ([127.0.0.1]) by localhost (awaks.indabamobile.co.za [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jt23brvRkdcX for ; Wed, 24 Aug 2011 12:11:10 +0200 (SAST) Received: from [41.7.82.225] (unknown [41.7.82.225]) (Authenticated sender: renatods@indabamobile.co.za) by awaks.indabamobile.co.za (Postfix) with ESMTPA id E0C6B881B6E for ; Wed, 24 Aug 2011 12:11:09 +0200 (SAST) Message-ID: <4E54CE3D.9070301@indabamobile.co.za> Date: Wed, 24 Aug 2011 12:11:09 +0200 From: Renato Bacelar da Silveira User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.2.17) Gecko/20110424 Thunderbird/3.1.10 MIME-Version: 1.0 To: "user@cass" Subject: Cassandra-CLI does not allow list 1105115; with Syntax error Content-Type: multipart/alternative; boundary="------------060007080106050507090809" This is a multi-part message in MIME format. --------------060007080106050507090809 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 ; list [:]; list [:]; list [:] 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 --------------060007080106050507090809 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit  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
--------------060007080106050507090809--