En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
AWS re:Postre:Post

DynamoDB PartiQL vs. Scan

0

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 EXPERT
    il y a 3 mois

    please accept the answer if it was helpful

Sujets
Base de données
Balises
Amazon DynamoDB
Langue
English
rePost-User-4717319
demandé il y a 3 mois225 vues
1 réponse
0

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.

profile picture
EXPERT
Oleksii Bebych
répondu il y a 3 mois
profile pictureAWS
EXPERT
Didier_Durand
vérifié il y a 3 mois
  • rePost-User-4717319
    il y a 3 mois

    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 EXPERT
    il y a 3 mois

    I'm not sure

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents