Monday, April 15, 2013

Trying Cassandra CQL

Here is how to create a new column on the fly in Cassandra's CQL2:


cqlsh:Keyspace2> select * from users;
 user_name | birth_year | gender | password   | session_token | state
-----------+------------+--------+------------+---------------+-------
   jsmith3 |       null |   null |        200 |          null |  null
    jsmith |       1968 |   null |  ch@ngem3a |          null |  null
   jsmith2 |       1963 |   null | ch@ngem3a2 |          null |  null

cqlsh:Keyspace1> insert into users (KEY, x) values ('jsmith',100);
cqlsh:Keyspace1> select * from users;
 KEY,TEST | birth_year,1968 | gender,m
 KEY,TEST1 | birth_year,1968 | gender,f
 KEY,jsmith | x,100



0 comments:

Post a Comment

Note: Only a member of this blog may post a comment.