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

주제

데이터베이스

태그

아마존 DynamoDB

언어

English

rePost-User-4717319

질문됨 3달 전225회 조회

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

관련 콘텐츠