Re: Create CF with composite column through CQL 3

2012-10-31 Thread Wei Zhu
r by a non-EQ relation) Thanks. -Wei From: Tristan Seligmann To: user@cassandra.apache.org; Wei Zhu Sent: Wednesday, October 31, 2012 10:47 AM Subject: Re: Create CF with composite column through CQL 3 On Wed, Oct 31, 2012 at 7:14 PM, Wei Zhu wrote: > I

Re: Create CF with composite column through CQL 3

2012-10-31 Thread Tristan Seligmann
On Wed, Oct 31, 2012 at 7:14 PM, Wei Zhu wrote: > I try to use CQL3 to create CF with composite columns, > > CREATE TABLE Friends ( > ... user_id bigint, > ... friend_id bigint, > ... status int, > ... source int, > ... created time

Re: Create CF with composite column through CQL 3

2012-10-31 Thread Timmy Turner
CQL3 handles columns/rows/keys differently than Cassandra itself underneath. If you look closely you'll see that your real primary key is in fact only a Long: > Key Validation Class: org.apache.cassandra.db.marshal.LongType If you want to know more about it, check these 2 articles: http://

Re: Create CF with composite column through CQL 3

2012-10-31 Thread Sylvain Lebresne
You didn't do anything wrong, it's how CQL3 works. I suggest having a look at http://www.datastax.com/dev/blog/thrift-to-cql3. Especially the section called "Non compact tables" might hopefully explains more. -- Sylvain On Wed, Oct 31, 2012 at 6:14 PM, Wei Zhu wrote: > I try to use CQL3 to creat

Create CF with composite column through CQL 3

2012-10-31 Thread Wei Zhu
I try to use CQL3 to create CF with composite columns,  CREATE TABLE Friends (          ...     user_id bigint,          ...     friend_id bigint,          ...     status int,          ...     source int,          ...     created timestamp,          ...     lastupdated timestamp,          ...