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

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
主站蜘蛛池模板: 麟游县| 承德市| 白城市| 彭泽县| 锦州市| 正蓝旗| 宁武县| 绥江县| 德清县| 同心县| 日照市| 灵石县| 楚雄市| 竹北市| 乐昌市| 锡林郭勒盟| 额敏县| 滨州市| 合阳县| 开化县| 贞丰县| 册亨县| 加查县| 来安县| 广水市| 三原县| 梁平县| 都兰县| 十堰市| 湘潭市| 武义县| 马边| 宾阳县| 许昌县| 桓台县| 利辛县| 齐齐哈尔市| 康平县| 墨竹工卡县| 通许县| 介休市|