Hello, Considering the below use-case: - create DynamoDB table with local index, from Management Console (Local Index Sort Key same name as Table Partition Key; need to query table PK) - create one Item in the table from Management Console - expect that the index will contain data related to the created item - Management Console PartiQL returns the data from table - when use Management Console PartiQL to select data from index, no data is returned : `select * from PictureTextKeyPhrases.PartitionKeyIndex` Why is this behaviour ? Thank you, Mihai ADAM

DynamoDB local index not updated when data inserted in table

Hello,

Considering the below use-case:

create DynamoDB table with local index, from Management Console (Local Index Sort Key same name as Table Partition Key; need to query table PK)
create one Item in the table from Management Console
expect that the index will contain data related to the created item
Management Console PartiQL returns the data from table
when use Management Console PartiQL to select data from index, no data is returned : select * from PictureTextKeyPhrases.PartitionKeyIndex

Why is this behaviour ?

Thank you,
Mihai ADAM

トピック

データベース

タグ

Amazon DynamoDB

言語

English

rePost-User-4717319

質問済み 1ヶ月前111ビュー

1回答

新しい順
投票が多い順
コメントが多い順

The reason for your issue is how you define your statement, DynamoDB thinks you are trying to access a table called PictureTextKeyPhrases.PartitionKeyIndex, however your table is PictureTextKeyPhrases and your index PartitionKeyIndex, so you should use the following syntax:

SELECT * FROM "PictureTextKeyPhrases"."PartitionKeyIndex"

エキスパート

Leeroy Hannigan

回答済み 1ヶ月前

エキスパート

Giovanni Lauria

レビュー済み 1ヶ月前

DynamoDB local index not updated when data inserted in table

関連するコンテンツ