wiki:table_example1

Version 1 (modified by liaojiaohe, 14 years ago) (diff)

--

场景大概是:需要记录大量用户的操作Action,需要查询用户最新的行为

采用数据库设计有类似的SQL

SELECT id, name, stamp FROM actions WHERE userid = 1
ORDER BY stamp DESC LIMIT 10 OFFSET 20;
NSERT INTO actions (id, userid, name, stamp) VALUES (newid(), 1, 'Joe User', epoch());

如果采用HBASE设计,ROW设计为<userid><reverse_order_stamp><actionid>