From user-return-21236-apmail-cassandra-user-archive=cassandra.apache.org@cassandra.apache.org Sun Oct 2 11:30:52 2011 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 BD303740C for ; Sun, 2 Oct 2011 11:30:52 +0000 (UTC) Received: (qmail 8640 invoked by uid 500); 2 Oct 2011 11:30:50 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 8615 invoked by uid 500); 2 Oct 2011 11:30: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 8607 invoked by uid 99); 2 Oct 2011 11:30:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2011 11:30:50 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.113.200.5] (HELO homiemail-a43.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 02 Oct 2011 11:30:45 +0000 Received: from homiemail-a43.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a43.g.dreamhost.com (Postfix) with ESMTP id 483A28C058 for ; Sun, 2 Oct 2011 04:30:19 -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=ZhALHbrNvZ 2AzMEO1pK/Lz+y4oI4AgjduaS8oE1dc0sW1cX1xrSa1ZsOo6g7JOOq+L9GYvbpp6 ytiFRfuqli9PFxis6opneZXCcDQad/u9LJa4vpep07C4cKLeRTALReCKyyHHd9Yr ydalyIcExB72Nn6nJYKUJkV2hbL+oI4UU= 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=+nh2r0vmZtZMgu66 UczT3myMu/Y=; b=MjU37RoCGSgBZ31852aUeDdIaYIRTzzP8Wq2DblI4eh+V/fW AKgZZAJNYNn0T/nF7lRZt2/jiAxaFGqngH9zmvRGvyy5WnRB4EMiVgRGRuYZXJvk BQsYxBGfgPUdJCY6STTLE+9zZl4DOUs4H7XaJy8kahg/cMlUH2hYUMm1tsg= Received: from [172.16.1.4] (219-89-3-86.dialup.xtra.co.nz [219.89.3.86]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a43.g.dreamhost.com (Postfix) with ESMTPSA id B0DE28C056 for ; Sun, 2 Oct 2011 04:30:18 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1244.3) Content-Type: multipart/alternative; boundary="Apple-Mail=_59478882-3C16-4CE9-8D28-12FF43452851" Subject: Re: create super column family for Date: Mon, 3 Oct 2011 00:30:15 +1300 In-Reply-To: To: user@cassandra.apache.org References: <1530694168-1317355850-cardhu_decombobulator_blackberry.rim.net-1347792966-@b18.c2.bise3.blackberry> Message-Id: <946D72FC-818A-4B9A-8811-FE915E1890AF@thelastpickle.com> X-Mailer: Apple Mail (2.1244.3) --Apple-Mail=_59478882-3C16-4CE9-8D28-12FF43452851 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 That is not a valid statement, were you getting an error ?=20 This creates the ProductCategory CF . create column family ProductCategory with column_type =3D 'Super' and comparator =3D UTF8Type; This creates the ProductCatID CF create column family ProductCatId WITH comparator =3D UTF8Type AND key_validation_class=3DUTF8Type AND column_metadata =3D [ {column_name: subProdName, validation_class: UTF8Type} {column_name: lenght, validation_class: UTF8Type} {column_name: width, validation_class: UTF8Type} ]; See the help in the CLI for more info.=20 Hope that helps.=20 ----------------- Aaron Morton Freelance Cassandra Developer @aaronmorton http://www.thelastpickle.com On 1/10/2011, at 3:38 AM, Ramesh S wrote: > I am using 0.8.6. >=20 > On Thu, Sep 29, 2011 at 11:10 PM, Yi Yang wrote: > Which version are you using? In my memory 0.8.3 cannot do it correctly = but later versions fixed the bug. >=20 > =E5=BE=9E=E6=88=91=E7=9A=84 BlackBerry=C2=AE =E7=84=A1=E7=B7=9A=E8=A3=9D= =E7=BD=AE >=20 > From: Ramesh S > Date: Thu, 29 Sep 2011 15:23:29 -0500 > To: > ReplyTo: user@cassandra.apache.org > Subject: create super column family for >=20 > I am trying to create a super column family using Cli command. > But I am not getting it. >=20 > The structure is=20 >=20 > <>ProductCategory > <>#ProductType > <>#productCatId > +subProdName > +lenght > +width >=20 > I tried a lot many ways but I can't find the right way to get this = done. > Something like this give me error - mismatched input 'column' = expecting Identifier > create column family ProductCategory > with column_type =3D 'Super' > and comparator =3D UTF8Type > with column family productCatId > WITH comparator =3D UTF8Type > AND key_validation_class=3DUTF8Type > AND column_metadata =3D [ > {column_name: subProdName, validation_class: UTF8Type} > {column_name: lenght, validation_class: UTF8Type} > {column_name: width, validation_class: UTF8Type} > ]; > =20 > Appreciate any help >=20 > regards > Ramesh >=20 --Apple-Mail=_59478882-3C16-4CE9-8D28-12FF43452851 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 WITH comparator =3D = UTF8Type
AND = key_validation_class=3DUTF8Type
AND column_metadata =3D = [
= {column_name: subProdName, validation_class: = UTF8Type}
{column_name: lenght, = validation_class: UTF8Type}
{column_name: width, = validation_class: UTF8Type}
];

See the help in the CLI = for more info. 

Hope that = helps. 

http://www.thelastpickle.com

On 1/10/2011, at 3:38 AM, Ramesh S wrote:

I am using = 0.8.6.

On Thu, Sep 29, 2011 at 11:10 = PM, Yi Yang <i@iyyang.com> = wrote:
Which version are you using? In my memory 0.8.3 cannot do it = correctly but later versions fixed the bug.

=E5=BE=9E=E6=88=91=E7= =9A=84 BlackBerry=C2=AE =E7=84=A1=E7=B7=9A=E8=A3=9D=E7=BD=AE


<= b>From: Ramesh S <investtrco@gmail.com>
Date: Thu, 29 Sep 2011 15:23:29 -0500
Subject: create super column family = for

I am = trying to create a super column family using Cli command.
But = I am not getting it.

The structure = is 

<<SCF>>ProductCategory
=
<<SuperColumnName>>#ProductType
=
<<RowKey>>#productCatId
+subProdName
= +lenght
+width

I tried a lot = many ways but I can't find the right way to get this = done.
Something like this give me error - mismatched input = 'column' expecting Identifier
create column family ProductCategory
    with = column_type =3D 'Super'
    and comparator =3D = UTF8Type
with column family productCatId
WITH = comparator =3D UTF8Type
AND key_validation_class=3DUTF8Type
AND column_metadata =3D [
{column_name: subProdName, = validation_class: UTF8Type}
{column_name: lenght, = validation_class: UTF8Type}
{column_name: width, = validation_class: UTF8Type}
];
    
Appreciate any = help

regards
Ramesh


= --Apple-Mail=_59478882-3C16-4CE9-8D28-12FF43452851--