I think the confusion here is that cassandra-cli and cqlsh have different syntaxes.
On Fri, Mar 30, 2012 at 4:37 PM, aaron morton <aa...@thelastpickle.com>wrote: > Background: > 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='' AND > comparator=text AND > row_cache_provider='ConcurrentLinkedHashCacheProvider' AND > key_cache_size=200000.000000 AND > row_cache_size=0.000000 AND > read_repair_chance=0.100000 AND > gc_grace_seconds=864000 AND > default_validation=text AND > min_compaction_threshold=4 AND > max_compaction_threshold=32 AND > row_cache_save_period_in_seconds=0 AND > key_cache_save_period_in_seconds=14400 AND > replicate_on_write=True; > > cqlsh:dev> > > 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?? > > 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.agra...@impetus.co.in> 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:puneetl...@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 ‘Cloud-enabled Performance Testing vis-à-vis >> On-premise’ 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. >> > > >
