如何在DynamoDB的主键上使用begins_with方法？ [英] How can I Use begins_with method on primary key in DynamoDB?

问题描述

我有2个属性id（字符串，主键），value（字符串）的表。
当我尝试跟随KeyConditionExpression时，它抛出不支持查询键条件。

I have Table with 2 attribute id(string,primary key), value(string). When I try follwoing KeyConditionExpression it throws Query key condition not supported.

KeyConditionExpression: "begins_with(ID, :tagIDValue)" 
                        or
KeyConditionExpression: "contains(ID, :tagIDValue)"

从此链接中得知我们只能在主键上使用EQ操作。我该如何实现

From this link I came to know we can use only EQ operations on main key. How can I achieve this

解决方案：=========================== ============================

我需要

表属性：PK（partion_key，字符串），ID（排序键，字符串），value（字符串） ）。

Table attributes: PK(partion_key, string), ID(sort key, string), value(string).

现在，我的主键基于PK，ID构成框架

Now my primary key is framed based on PK,ID

PK对所有对象都具有恒定值行。

PK will have constant value for all rows. so KeyConditionExpression will be like.

KeyConditionExpression: "PL = :pk  and begins_with(ID, :tagIDValue)"

注意：但仍然包含不适用于KeyConditionExpression。我认为它已从KeyConditionExpression中删除

NOTE: But still contains not working with KeyConditionExpression. I think it was removed from KeyConditionExpression

推荐答案

您可以使用 begins_with 和包含仅带有范围键。

You can use begins_with and contains only with a range key after specifying an EQ condition for the primary key.

要使用使用主键可以执行EQ

To use EQ with the primary key you can do

KeyConditionExpression: "ID = :tagIDValue"

这篇关于如何在DynamoDB的主键上使用begins_with方法？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！