incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cyril Auburtin <cyril.aubur...@gmail.com>
Subject cql3 and cli composites columns
Date Tue, 02 Oct 2012 07:35:04 GMT
wanted to know why the two last lines 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

Mime
View raw message