有没有办法在 DynamoDB 中查询多个哈希键? [英] Is there a way to query multiple hash keys in DynamoDB?

问题描述

有没有办法在亚马逊的 AWS SDK for Java 中使用单个查询来查询多个哈希键?

Is there a way to query multiple hash keys using a single query in Amazon's AWS SDK for Java?

这是我的问题；我有一个项目状态的数据库表.哈希键是项目的状态(即:新建、分配、处理或完成).范围键是一组项目 ID.目前，我有一个查询设置来简单地查找列为已分配"状态(哈希)的所有项目和另一个查询设置来查找处理"状态.有没有办法使用单个查询来执行此操作，而不是为我需要查找的每个状态发送多个查询?代码如下:

Here's my issue; I have a DB table for project statuses. The Hash Key is the status of a project (ie: new, assigned, processing, or complete). The range key is a set of project IDs. Currently, I've got a query setup to simply find all the projects listed as a status(hash) of "assigned" and another query set to look for a status of "processing". Is there a way to do this using a single query rather than sending multiple queries for each status I need to find? Code below:

    DynamoDBMapper mapper = new DynamoDBMapper(new AmazonDynamoDBClient(credentials));
    PStatus assignedStatus = new PStatus();
    assignedStatus.setStatus("assigned");
    PStatus processStatus = new PStatus();
    processStatus.setStatus("processing");

    DynamoDBQueryExpression<PStatus> queryAssigned = new DynamoDBQueryExpression<PStatus>().withHashKeyValues(assignedStatus);
    DynamoDBQueryExpression<PStatus> queryProcessing = new DynamoDBQueryExpression<PStatus>().withHashKeyValues(processStatus);

    List<PStatus> assigned = mapper.query(PStatus.class, queryAssigned);
    List<PStatus> process = mapper.query(PStatus.class, queryProcessing);

所以基本上，我想知道是否可以消除 queryAssigned 和 assigned 变量并同时处理 assignedStatus 和 processStatus 通过相同的查询 process 来查找不是新的或不完整的项目.

So basically, I'd like to know if it's possible to eliminate the queryAssigned and assigned variables and handle both assignedStatus and processStatus via the same query, process, to find projects that are not new or complete.

推荐答案

不，截至目前，无法在同一个请求中发送多个查询.如果您担心延迟，您可以在不同的线程中同时发出多个请求.如果 Dynamo 提供它，这将需要与双重查询"相同数量的网络带宽(假设您制作 2​​ 个，而不是数百个).

No, as of today there is no way to send multiple queries in the same request. If you're concerned about latency, you could make multiple requests simultaneously in different threads. This would require the same amount of network bandwidth as a "dual query" would if Dynamo offered it (assuming you're making 2, not hundreds).

这篇关于有没有办法在 DynamoDB 中查询多个哈希键?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！