深山中 2022-04-18 16:31 采纳率: 80%
浏览 37
已结题

Cassandra数据库怎么多表关联查询?

Cassandra(NoSQL数据库系统)怎么多表关联查询?

  • 写回答

1条回答 默认 最新

  • blackoon88 2022-04-20 17:09
    关注

    官方建议如下(简单的来说就是你最好把表设计成无关联的宽表,不支持join):

    Design Differences Between RDBMS and Cassandra

    No joins
    You cannot perform joins in Cassandra. If you have designed a data model and find that you need something like a join, you’ll have to either do the work on the client side, or create a denormalized second table that represents the join results for you. This latter option is preferred in Cassandra data modeling. Performing joins on the client should be a very rare case; you really want to duplicate (denormalize) the data instead.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

问题事件

  • 系统已结题 5月4日
  • 已采纳回答 4月26日
  • 创建了问题 4月18日