Stack Overflow
Stack Overflow

Questions tagged [amazon-dynamodb-index]

251 questions
0
votes
1 answer

Querying the Dynamodb

I've a table of cars. with the items, CarName, ModelYear, Color, Transmission, Used-Mileage. how can I query the car by just ModelYear or just color or just Transmission? I mean, how can I specifically query the data, available in the table.
Hassan
  • 101
  • 1
  • 1
  • 6
0
votes
0 answers

dynamodb Local, duplicate key

I'm using dynamodb Local. I'm trying to assign two addresses to one person but I'm getting a "Duplicate Key" error. I want to add more countries and more addresses for one single person. but whenever I try to add another country and address for the…
Hassan
  • 101
  • 1
  • 1
  • 6
0
votes
2 answers

Identify trigger or find dynamodb table name from lambda function code

I have a nodejs lambda function with three dynamodb tables associated via trigger. I am indexing the records to elasticsearch based on the event fired using the lambda function code. Basically, I need to find out the table name in which the records…
Dinesh Kumar
  • 2,838
  • 1
  • 16
  • 18
0
votes
1 answer

Benefit of local index in AWS DynamoDB?

In DynamoDB I have a table like below example data pk sk name price ======================================================= product cat#phone#name#iPhone11 iPhone 11 500 product …
Niloy Rony
  • 602
  • 1
  • 8
  • 23
0
votes
0 answers

Update already in Cloud DynamoDB Data Model using NoSQL Workbench

Is it possible to update my already in Cloud created DynamoDB Model from the Workbench? For instance i'd like in the future to add more fields and more Global indexes, how can I commit this changes from my NoSQL Workbench? The only option I see to…
ElKePoN
  • 822
  • 11
  • 21
0
votes
0 answers

Can I query a secondary index for a list of values in DynamoDB?

Can I query a secondary index for a list of values in DynamoDB? Partition key: accountId Sort Key: fieldId I want to query fieldId for a list of values. .withKeyCondition( S(“accountId”).eq(accountId) .and(S(“fieldId”).in(“companyType”,…
Jo Sa
  • 1
  • 1
0
votes
1 answer

How can i use Parallel Scan of AWS DynamoDB to run scan on a specific GSI?

I have a DynamoDB table where each Item has a key of the name 'DataType'. Also there is a GSI on this table with this 'DataType' as the HashKey and 'timestamp' as rangeKey. Around 10 per cent of the table items have the 'DataType' value as 'A'. I…
AksTester
  • 121
  • 1
  • 9
0
votes
1 answer

How to decrease the query time DynamoDB

I am setting up DynamoDB. Our data is simple, it has four fields: UserName UserShiftEndDate UserProjectCode UserActivities Ideally, we should query the users based on the UserShiftEndDate. None of the fields/combination in our data is unique. I…
NewBee
  • 33
  • 3
0
votes
2 answers

DynamoDB secondary index is not unique?

I have set a secondary index with only a partition key (without a sort key), but I found that actually I can insert multiple items with the same partition key. If I issue a query using the partition key in the secondary index, I'll get all the items…
yaquawa
  • 6,690
  • 8
  • 35
  • 48
0
votes
2 answers

Fetching parent and child item in single query in DynamoDB

I have the following one-to-many relationship: Account 1--* User The Account contains global account-level information, which is mutable. The User contains user-level information, which is also mutable. When the user signs-in, they need both…
Lawrence Wagerfield
  • 6,471
  • 5
  • 42
  • 84
0
votes
1 answer

How to create a DynamoDB Global Secondary Index with a hash of multiple fields?

To me, the word "hash" conveys that it IS possible to a hash consisting of multiple fields within DynamoDB. However, every article I find shows the "hash" consisting of only a single value... which doesn't make any sense to me. My table consists of…
G. Deward
  • 1,542
  • 3
  • 17
  • 30
0
votes
1 answer

Dynamo - Increased Read Latency During Writes

There is a DynamoDB table Entity which has a hash key on id and GSI on another attribute: cardId. The GSI only has range key and does not have any sort key. Whenever, we get a batch of create/update requests, we first use the GSI to read existing…
ezile
  • 571
  • 2
  • 6
  • 20
0
votes
1 answer

is it correct to use a DynamoDB scan operation with pagination instead of query with GSI, I need all the items from the table

I read that dynamo db scan operation is slow when the data is large . but i want to know that, Having a scenario to extract all the items. Is it still preferred to avoid scan ? considering indexes are not free and i need all the items from table, i…
vrk
  • 5
  • 3
0
votes
1 answer

how to get the records using partition key from a composite primary key in dynamodb

I am using java to insert and retrieve records in DynamoDB. Insertion Code Item item_to_insert = new Item().withPrimaryKey("LatLong", key,"location_code",key) .withJSON("location_address",…
stg
  • 67
  • 1
  • 6
0
votes
0 answers

AWS DynamoDB index did not get populated

I have a table with some data already. Then I created a few indexes over time. The oldest index has all the items, but two other indexes I created recently were empty. Today I deleted those two indexes and created again. Now they have only 19 items…
Kostiantyn
  • 1,792
  • 2
  • 16
  • 21
1 2 3
…
16 17