官术网_书友最值得收藏!

Beyond Key-Value Lookup

In the last chapter, we explored a powerful data organization concept in Cassandra - the compound primary key. This allowed us to construct a table for status updates that satisfies two important requirements: related data is grouped together, and records have a built-in ordering within each group. So far, however, we only have two tools for querying data: either retrieve a single row using its full primary key, or retrieve all the rows in a table. In this chapter, we will pe into the more sophisticated queries that are available on tables with clustering columns, and use these queries to build the main reading interface for our MyStatus application. By the end of this chapter, you'll know:

  • How to retrieve all rows within a single partition
  • How to retrieve rows within a range of clustering column values
  • How to paginate over rows in a single partition
  • How to change the order of results
  • How to store rows in descending order of clustering column
  • How to paginate over all rows in a compound primary key table
  • How to construct autocomplete functionality using a compound primary key table
主站蜘蛛池模板: 龙口市| 巨鹿县| 天长市| 水富县| 黄石市| 天台县| 崇信县| 偃师市| 涿州市| 通城县| 九台市| 临夏县| 磐安县| 彭阳县| 高唐县| 甘洛县| 临海市| 当阳市| 建水县| 威宁| 泰来县| 邛崃市| 西青区| 无为县| 微山县| 尖扎县| 巩留县| 德清县| 无锡市| 大邑县| 胶州市| 绩溪县| 屯留县| 呼伦贝尔市| 梧州市| 商城县| 南丰县| 肥东县| 抚松县| 嘉义市| 武威市|