How to use LastEvaluatedKey in ExecuteStatement request?

0

According to the documentation for ExecuteStatement:

If LastEvaluatedKey is present in the response, you need to paginate the result set.

How can I use LastEvaluatedKey if ExecuteStatement request has no ExclusiveStartKey parameter as Scan and Query.

I cannot use NextToken because it is not returned when Limit is specified.

질문됨 2년 전1204회 조회
1개 답변
2
수락된 답변

This is something the team are currently working on. When you use Limit you are not returned a NextToken, but a LastEvaluatedKey, and due to the lack of ExclusiveStartKey it cannot be used for Pagination. Unfortunately I do not have an ETA on the fix, but it is being worked on priority.

For now, if you are using Query you can alter your request to add the SK of the LastEvaluatedKey:

SELECT * FROM mytable WHERE PK='x' AND SK > {SK returned in LEK}

Hope that helps

profile pictureAWS
전문가
답변함 2년 전
  • @Leeroy,

    Also running into this issue with first ExecuteStatement. But I do get a "NextToken" returned but when we fed it into the next "ExecuteStatement" as part of input, we keep getting an error "NextToken does not match request".

    1. Is this the same issue quoted?
    2. if so, do we have any estimated timeline?

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠