Database Reference
In-Depth Information
values('imvivek','2014-01-04','Working on
Cassandra book on weekend','vivek');
3.
Let's store a few columns in the
users
column family for user_id
'jhassell'
:
// insert records for 'jhassel'
insert into
users(user_id,tweet_date,tweet_body,first_name)
values('jhassell','2013-12-21','2013 bye
bye','jonathan');
insert into
users(user_id,tweet_date,tweet_body,first_name)
values('jhassell','2014-01-01','2014! another
exciting year','jonathan');
insert into
users(user_id,tweet_date,tweet_body,first_name)
values('jhassell','2014-03-25','Cassandra
book, rolling out!','jonathan');
4.
Let's try to fetch rows ordered by
tweet_date
in descending order
(see
Figure 3-5
).
select * from users where user_id='imvivek'
order by tweet_date DESC;
Figure 3-5
output shows rows sorted by tweet_date for user_id
imvivek
Figure 3-5
.
Users with user_id imvivek, sorted by tweet date