Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
MIME-Version: 1.0
In-Reply-To: 
 <CAKteAhHsUycTWqhvcK2fpZDR5mPKU1or60jgDfhcggFDYWsfrw@mail.gmail.com>
References: 
 <CAKteAhH9tXAWWdGSi=YnvniVq8xoBkrMepH8k5ri2TT811SNYg@mail.gmail.com>
	<62429F36-D470-43DA-A9EB-90CB21E160A9@thelastpickle.com>
	<CAKteAhHsUycTWqhvcK2fpZDR5mPKU1or60jgDfhcggFDYWsfrw@mail.gmail.com>
Date: Sun, 7 Oct 2012 19:04:42 -0400
Message-ID: 
 <CADjRqh-bzSVspWMFodWt=irqM55xEhLZDVjWiP01CnEvRCwYRg@mail.gmail.com>
Subject: Re: cql3 and cli composites columns
From: Tupshin Harper <tupshin@tupshin.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Once you have created the CF from cqlsh, switch over to cassandra-cli
and run "describe schema". It will show you the schema for all your
column families in syntax that can be passed back into cassandra-cli
to create them.

The cassandr-cli syntax that you are looking for is probably the "and
column_metadata =" section.

-Tupshin

On Sun, Oct 7, 2012 at 4:43 PM, Cyril Auburtin <cyril.auburtin@gmail.com> wrote:
> Thanks Aaron,
> I don't understand what is the cli equivalent of:
>
> CREATE TABLE timeline (
>           user_id varchar,
>           tweet_id bigint,
>           author varchar,
>           body varchar,
>           PRIMARY KEY (user_id, tweet_id)
>         );
>
>
>
> 2012/10/3 aaron morton <aaron@thelastpickle.com>
>>
>> > If it's just a printing issue it's really minor though
>>
>> I would guess because  timeline CF has defined columns and line CF does
>> not.
>>
>> All cqlsh knows is that every column name has two parts, it does not know
>> what the column names will be. The difference between a static and dynamic
>> CF.
>>
>> Hope that helps.
>>
>> -----------------
>> Aaron Morton
>> Freelance Developer
>> @aaronmorton
>> http://www.thelastpickle.com
>>
>> On 2/10/2012, at 10:37 PM, Cyril Auburtin <cyril.auburtin@gmail.com>
>> wrote:
>>
>> > I wanted to know why the highlighted sections below are printed
>> > differently, the 2 column families are the same
>> >
>> > Key Validation Class: org.apache.cassandra.db.marshal.UTF8Type
>> > Default column value validator: org.apache.cassandra.db.marshal.UTF8Type
>> > Columns sorted by:
>> > org.apache.cassandra.db.marshal.CompositeType(org.apache.cassandra.db.marshal.LongType,org.apache.cassandra.db.marshal.UTF8Type)
>> >
>> > , except one is created from cql3:
>> >
>> > If it's just a printing issue it's really minor though
>> >
>> > on cql3:
>> > CREATE TABLE timeline (
>> >         ...   user_id varchar,
>> >         ...   tweet_id bigint,
>> >         ...   author varchar,
>> >         ...   body varchar,
>> >         ...   PRIMARY KEY (user_id, tweet_id)
>> >         ... );
>> > INSERT INTO timeline (user_id, tweet_id, author, body) VALUES ('gmason',
>> > 1765, 'phenry', 'Give me liberty or give me death');
>> >
>> >
>> > on CLI:
>> >
>> > create column family line with comparator = 'CompositeType(LongType,
>> > UTF8Type)' AND key_validation_class=UTF8Type AND default_validation_class =
>> > UTF8Type;
>> > set line['dude']['1545:ok'] = '1';
>> > set line['dude']['1545:ok1'] = '11111';
>> >
>> > list timeline;
>> > RowKey: gmason
>> > => (column=1765:author, value=phenry, timestamp=1349161331154000)
>> > => (column=1765:body, value=Give me liberty or give me death,
>> > timestamp=1349161331154001)
>> >
>> > list line;
>> > RowKey: dude
>> > => (column=1545:ok, value=1, timestamp=1349162658714000)
>> > => (column=1545:ok1, value=11111, timestamp=1349162638658000)
>> >
>> > on cql3:
>> >
>> > select * from timeline;
>> >  user_id | tweet_id | author | body
>> > ---------+----------+--------+----------------------------------
>> >   gmason |     1765 | phenry | Give me liberty or give me death
>> >
>> >
>> > select * from line;
>> >  key  | column1 | column2 | value
>> > ------+---------+---------+-------
>> >  dude |    1545 |      ok |     1
>> >  dude |    1545 |     ok1 | 11111
>> >
>> >
>> >
>> > ps: I have tried
>> >
>> > update column family line with comparator = 'CompositeType(LongType,
>> > UTF8Type)' AND key_validation_class=UTF8Type AND column_metadata = [
>> > {column_name: tweet_id, validation_class: LongType}
>> > {column_name: author, validation_class: UTF8Type}
>> > {column_name: body, validation_class: UTF8Type}
>> > ];
>> > for the CF line but it gives:
>> > java.lang.RuntimeException:
>> > org.apache.cassandra.db.marshal.MarshalException: unable to make long from
>> > 'tweet_id'
>> >
>>
>