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 專家
4 個月前
please accept the answer if it was helpful

主題

資料庫

標籤

Amazon DynamoDB

語言

English

rePost-User-4717319

已提問 4 個月前檢視次數 234 次

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

已回答 4 個月前

專家

Didier_Durand

已審閱 4 個月前

rePost-User-4717319
4 個月前
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 專家
4 個月前
I'm not sure

DynamoDB PartiQL vs. Scan

相關內容