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 0BCC39E88 for ; Fri, 30 Mar 2012 23:38:08 +0000 (UTC) Received: (qmail 30939 invoked by uid 500); 30 Mar 2012 23:38:05 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 30885 invoked by uid 500); 30 Mar 2012 23:38:05 -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 30877 invoked by uid 99); 30 Mar 2012 23:38:05 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Mar 2012 23:38:05 +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-a92.g.dreamhost.com) (208.113.200.5) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Mar 2012 23:38:00 +0000 Received: from homiemail-a92.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a92.g.dreamhost.com (Postfix) with ESMTP id BE6BE3DC065 for ; Fri, 30 Mar 2012 16:37:39 -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=Pif9Kc96RI jXV1ZBqLqEn8vwpqtDN05z7o+3txklsVk87VUV5nmSbKPUAIdZLhCi4ULJ/qkotG yVRWT91dPCFTgZx5TI0i4/MD99MPI9m/YocHnZFY1xTQdr89EpKqyqepzUxbt2Ns CcmZsMENFqRYE56e7Tg8gQJlsEY/qWksQ= 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=Z9WL54WoOTpUGXVq nEQKFFnwpDo=; b=njyirPKD4AwP8EOpdlMzBJspAGHxS4fssCJEzfj752/MzoRI SpBP9pHa25g2A03KSbNvA/AD0AhsQjzHhaslidBRwctOLl4afXZ/G55GWu7LXyEG eebtmw5RBbRZc4xb/iHFUmcDkoD3jETYKHQm5FLXX3yVzXntRhZHdy6EUJ4= Received: from [172.20.10.3] (41.157.224.49.dyn.cust.vf.net.nz [49.224.157.41]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) (Authenticated sender: aaron@thelastpickle.com) by homiemail-a92.g.dreamhost.com (Postfix) with ESMTPSA id 4C06E3DC05C for ; Fri, 30 Mar 2012 16:37:36 -0700 (PDT) From: aaron morton Mime-Version: 1.0 (Apple Message framework v1257) Content-Type: multipart/alternative; boundary="Apple-Mail=_0240BE12-032D-4B11-871F-D26FFF72C39A" Subject: Re: create column family Date: Sat, 31 Mar 2012 12:37:32 +1300 In-Reply-To: To: user@cassandra.apache.org References: Message-Id: X-Mailer: Apple Mail (2.1257) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail=_0240BE12-032D-4B11-871F-D26FFF72C39A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 Background: = http://www.datastax.com/docs/1.0/references/cql/CREATE_COLUMNFAMILY What error are you getting ? This works for me.=20 cqlsh> use dev; cqlsh:dev> create COLUMNFAMILY users ... (KEY uuid PRIMARY KEY, ... firstname text, ... lastname text, ... email text, ... address text, ... zip int, ... state text); cqlsh:dev> describe columnfamilies; users student cqlsh:dev> describe columnfamily users; CREATE COLUMNFAMILY users ( KEY uuid PRIMARY KEY, address text, lastname text, email text, firstname text, state text, zip int ) WITH comment=3D'' AND comparator=3Dtext AND row_cache_provider=3D'ConcurrentLinkedHashCacheProvider' AND key_cache_size=3D200000.000000 AND row_cache_size=3D0.000000 AND read_repair_chance=3D0.100000 AND gc_grace_seconds=3D864000 AND default_validation=3Dtext AND min_compaction_threshold=3D4 AND max_compaction_threshold=3D32 AND row_cache_save_period_in_seconds=3D0 AND key_cache_save_period_in_seconds=3D14400 AND replicate_on_write=3DTrue; cqlsh:dev>=20 Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 28/03/2012, at 2:22 AM, puneet loya wrote: > how to use cql?? >=20 > Rite now i m running dis file cassandra-cli.bat=20 >=20 > i connect localhost/9160; >=20 > den i went into use pun; //its a keyspace >=20 > using the create statement >=20 > create COLUMNFAMILY users >=20 > (KY uuid PRIMARY KEY, >=20 > firstname text, >=20 > lastname text, >=20 > email text, >=20 > address text, >=20 > zip int, >=20 > state text); >=20 > =20 > it is gining error?? >=20 > how to write in cql?? >=20 > do we have to shift to some other environment.. for using cql >=20 > On Tue, Mar 27, 2012 at 5:58 PM, Rishabh Agrawal = wrote: > If you are using cql then following statement is more apt: >=20 > =20 > create COLUMNFAMILY users >=20 > (KY uuid PRIMARY KEY, >=20 > firstname text, >=20 > lastname text, >=20 > email text, >=20 > address text, >=20 > zip int, >=20 > state text); >=20 > =20 > From: puneet loya [mailto:puneetloya@gmail.com]=20 > Sent: Tuesday, March 27, 2012 5:54 PM > To: user@cassandra.apache.org > Subject: create column family >=20 > =20 > create column family users >=20 > (uuid PRIMARY KEY >=20 > firstname text, >=20 > lastname text, >=20 > email text, >=20 > address text, >=20 > zip int, >=20 > state text); >=20 > =20 > =20 > Is dis above statement correct? >=20 > =20 > I m getting an error " Syntax error at position 27: missing EOF at = '(' " >=20 > =20 > Do reply >=20 > =20 > =20 > Can u suggest the most stable version of cassandra?? >=20 > =20 > =20 > =20 >=20 >=20 > Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. = Know more about our Big Data quick-start program at the event.=20 >=20 > New Impetus webcast =91Cloud-enabled Performance Testing vis-=E0-vis = On-premise=92 available at http://bit.ly/z6zT4L.=20 >=20 >=20 > NOTE: This message may contain information that is confidential, = proprietary, privileged or otherwise protected by law. The message is = intended solely for the named addressee. If received in error, please = destroy and notify the sender. Any use of this email is prohibited when = received in error. Impetus does not represent, warrant and/or guarantee, = that the integrity of this communication has been maintained nor that = the communication is free of errors, virus, interception or = interference. >=20 --Apple-Mail=_0240BE12-032D-4B11-871F-D26FFF72C39A Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 http://www.datastax.com/docs/1.0/references/cql/CREATE_COLUMNFAMILY=

What error are you getting ? This works for = me. 

cqlsh> use = dev;
cqlsh:dev> create COLUMNFAMILY users
  =      ... (KEY uuid  PRIMARY KEY,
  =      ... firstname text,
      =  ... lastname text,
       ... email = text,
       ... address = text,
       ... zip int,
  =      ... state text);
cqlsh:dev> describe = columnfamilies;

users =  student

cqlsh:dev> describe = columnfamily users;

CREATE COLUMNFAMILY users = (
  KEY uuid PRIMARY KEY,
  address = text,
  lastname text,
  email = text,
  firstname text,
  state = text,
  zip int
) WITH
  = comment=3D'' AND
  comparator=3Dtext AND
  = row_cache_provider=3D'ConcurrentLinkedHashCacheProvider' = AND
  key_cache_size=3D200000.000000 AND
  = row_cache_size=3D0.000000 AND
  = read_repair_chance=3D0.100000 AND
  = gc_grace_seconds=3D864000 AND
  default_validation=3Dtext = AND
  min_compaction_threshold=3D4 AND
  = max_compaction_threshold=3D32 AND
  = row_cache_save_period_in_seconds=3D0 AND
  = key_cache_save_period_in_seconds=3D14400 AND
  = replicate_on_write=3DTrue;

cqlsh:dev> 

Cheers

http://www.thelastpickle.com

On 28/03/2012, at 2:22 AM, puneet loya wrote:

how to use = cql??

Rite now i m running dis file = cassandra-cli.bat 

i connect = localhost/9160;

den i went into use pun; =  //its a keyspace

using the create statement

create COLUMNFAMILY users

(KY uuid  PRIMARY KEY,

firstname = text,

lastname = text,

email = text,

address = text,

zip = int,

state = text);

 
it is gining error??

how to write in = cql??

do we have to shift to some other = environment.. for using cql

On Tue, = Mar 27, 2012 at 5:58 PM, Rishabh Agrawal <rishabh.agrawal@impetus.co.i= n> wrote:

If you are using cql then following statement is = more apt:

 

create COLUMNFAMILY users

(KY uuid  PRIMARY = KEY,

firstname text,

lastname text,

email text,

address text,

zip int,

state text);

 

From: puneet loya [mailto:puneetloya@gmail.com]
Sent: Tuesday, March 27, 2012 5:54 PM
To: user@cassandra.apache.org
Subject: create column family

 

 create column family users

(uuid PRIMARY KEY

firstname text,

lastname text,

email text,

address text,

zip int,

state text);

 
 

Is dis above statement correct?

 

I m getting an error "  Syntax error at = position 27: missing EOF at '('  "

 

Do reply

 
 

Can u suggest the most stable version of = cassandra??

 
 
 


Impetus to sponsor and exhibit at Structure Data 2012, NY; Mar 21-22. = Know more about our Big Data quick-start program at the event.

New Impetus webcast =91Cloud-enabled Performance Testing vis-=E0-vis = On-premise=92 available at http://bit.ly/z6zT4L.


NOTE: This message may contain information that is confidential, = proprietary, privileged or otherwise protected by law. The message is = intended solely for the named addressee. If received in error, please = destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, = warrant and/or guarantee, that the integrity of this communication has = been maintained nor that the communication is free of errors, virus, = interception or interference.


= --Apple-Mail=_0240BE12-032D-4B11-871F-D26FFF72C39A--