DynamoDB PartiQL vs. Scan

Hello,

Is there a rule for the PartiQL queries on DynamoDB Sort Keys (e.g. indexes on SK) ?
The below query does not return anything from Table1 with Sort Key Table1SK and with condition on SK, while a scan on same table with filter 'level1#level2#level3#' on SK, returns records.

select Table1SK
from Table1
where begins_with("Table1SK", 'level1#level2#level3#')

Thank you,
Mihai ADAM

Oleksii Bebych 专家
3 个月前
please accept the answer if it was helpful

主题

数据库

标签

Amazon DynamoDB

语言

English

rePost-User-4717319

已提问 3 个月前224 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

To correctly query using PartiQL, ensure you include the partition key:

SELECT Table1SK
FROM Table1
WHERE Table1PK = 'somePartitionKey' AND begins_with(Table1SK, 'level1#level2#level3#')

Here, Table1PK should be replaced with the actual partition key attribute name and 'somePartitionKey' with the specific partition key value you want to query.

专家

Oleksii Bebych

已回答 3 个月前

专家

Didier_Durand

已审核 3 个月前

rePost-User-4717319
3 个月前
Hi,

Can the query be like below, or if multiple PKs needed, the only choice is to use few, with IN, OR clauses :

SELECT Table1SK FROM Table1 WHERE begins_with(Table1PK, 'somePartition') AND begins_with(Table1SK, 'level1#level2#level3#')

Thank you, Mihai ADAM
Oleksii Bebych 专家
3 个月前
I'm not sure

DynamoDB PartiQL vs. Scan

相关内容