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 907EB8D3D for ; Wed, 24 Aug 2011 21:10:33 +0000 (UTC) Received: (qmail 5787 invoked by uid 500); 24 Aug 2011 21:10:30 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 5610 invoked by uid 500); 24 Aug 2011 21:10:30 -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 5602 invoked by uid 99); 24 Aug 2011 21:10:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2011 21:10:29 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS,T_FRT_BELOW2 X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a53.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Aug 2011 21:10:22 +0000 Received: from homiemail-a53.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTP id 01EBF138069 for ; Wed, 24 Aug 2011 14:09:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; c=nofws; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; q=dns; s=thelastpickle.com; b=r22FQrfBzv PlA8zWJ0Cqlr25jNu7FTay2pNV1tYfN+s2UKL0EqtP+FMBVjifijgO/o/76IiA6j aXQZsGw9mbXSyHnFpRmiCC2vt45dKdLRQRgJx1Lv0SNJg2bbjhzf+oIdJOM8cJhP FXFBRetarGzdQdoBki3HWR3tEqDo5aiDY= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=thelastpickle.com; h=from :mime-version:content-type:subject:date:in-reply-to:to :references:message-id; s=thelastpickle.com; bh=3HqUTE5aAqniLGGM i9avvEsb++A=; b=T02/Rhe0dvIeiKrSyAx3z+rzQa69h6OUEeP7yFL8XFlwDElk bnKUeVOz/ZAMN1T1QPx+9b641obVpntl9Czv2xAHpVeRMT3OO3ahEAFJ4JgyQDNl 7S7cVl1TjP06QRjOsrSiHn6rUfeVjoiDIey/t2DyOBS+EldHR0pSx4Wyl3E= Received: from [172.16.1.4] (222-152-100-67.jetstream.xtra.co.nz [222.152.100.67]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a53.g.dreamhost.com (Postfix) with ESMTPSA id 02A2D138062 for ; Wed, 24 Aug 2011 14:09:57 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1244.3) Content-Type: multipart/alternative; boundary="Apple-Mail=_955268BD-D37D-4497-9A9B-F7BB986651E2" Subject: Re: Cassandra-CLI does not allow list 1105115; with Syntax error Date: Thu, 25 Aug 2011 09:09:56 +1200 In-Reply-To: <4E54D373.9020800@indabamobile.co.za> To: user@cassandra.apache.org References: <4E54D373.9020800@indabamobile.co.za> Message-Id: X-Mailer: Apple Mail (2.1244.3) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_955268BD-D37D-4497-9A9B-F7BB986651E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=iso-8859-1 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: >=20 > 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: [] >=20 > I do observe that the Key Validation is BytesType, so I also tried = (giddily)=20 >=20 > [default@unknown] list bytes(1105100); =20 > Syntax error at position 10: missing EOF at '(' >=20 > which confirmed that perhaps I should change the ColumFamily name? >=20 > Regards. >=20 > -------- 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 > Reply-To: user@cassandra.apache.org > To: user@cass >=20 > Hi All >=20 > Good day, >=20 > A question concerning Cassandra-Cli. >=20 > I have a Column Family named 11001500. >=20 > I have inserted the CF with Hector, and it did not=20 > throw any exception concerning the name of the > column. >=20 > If I am issuing the command >=20 > list 1105115; >=20 > I incur the following error: >=20 > [default@unknown] list 1105115; > Syntax error at position 5: mismatched input '1105115' expecting = Identifier >=20 > I presume we are not to name CFs as integers? >=20 > Or is there something I am missing from > the bellow help content: >=20 > [default@unknown] help list; > list ; > list [:]; > list [:]; > list [:] limit ; >=20 > List a range of rows, and all of their columns, in the specified = column > family. >=20 > The order of rows returned is dependant on the Partitioner in use. >=20 > Required Parameters: > - cf: Name of the column family to list rows from. >=20 > Optional Parameters: > - endKey: Key to end the range at. The end key will be included > in the result. Defaults to an empty byte array. >=20 > - limit: Number of rows to return. Default is 100. >=20 > - startKey: Key start the range from. The start key will be > included in the result. Defaults to an empty byte array. >=20 > Examples: > list Standard1; > list Super1[j:]; > list Standard1[j:k] limit 40; >=20 >=20 >=20 > Renato da Silveira > Senior Developer > www.indabamobile.co.za >=20 --Apple-Mail=_955268BD-D37D-4497-9A9B-F7BB986651E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=iso-8859-1 https://issu= es.apache.org/jira/browse/CASSANDRA-3054

can you = create a new ticket and link to that = one.


http://www.thelastpickle.com

On 24/08/2011, at 10:33 PM, Renato Bacelar da Silveira = wrote:

=20 =20
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.z= a>
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


= --Apple-Mail=_955268BD-D37D-4497-9A9B-F7BB986651E2--