Stack Overflow
Stack Overflow

Questions tagged [amazon-dynamodb-index]

251 questions
1
vote
1 answer

Rows entered with hard coded hashkey but with different range key

I'm trying to create a car booking app. Users can book cars located around many offices. Wondering if I could put ALL the bookings into a single hard coded hashkey "Bookings" but with unique Range Key. I want to have a reference to ALL the bookings…
Dimman
  • 1,186
  • 4
  • 14
  • 21
1
vote
1 answer

AWS DynamoDb : Pricing for On-demand Indexes

I need to create a secondary index on my DynamoDb table. For this table, I have set the read/write capacity mode to On-demand. To query the data based on a particular column in the table, I want to create an index. ( this column is sort key, so I…
Dattatray
  • 1,745
  • 1
  • 21
  • 49
1
vote
1 answer

Does spring-data-dynamodb support Local Secondary Index?

I'm using the spring-data-dynamodb in my project. I know that's possible to use Global Secondary Index (GSI), there's an example in the documentation. But, I need to use Local Secondary Indexes (LSI), I couldn't find any example of it. Do you know…
danilobraga
  • 165
  • 1
  • 9
1
vote
1 answer

DynamoDB - Does the number of GSIs influence the pricing on on-demand capacity mode?

My question is simple, instead of having one big GSI that maps several fields from many entities that I had to set common name like field_GSI_1, I want to create a separate GSI for each entity that I have. So, let's consider two scenarios. Scenario…
Mojimi
  • 2,561
  • 9
  • 52
  • 116
1
vote
1 answer

Use the same DynamoDB attribute as both HASH and RANGE key

I have a DynamoDB that is indexed by a single numerical key. I'd like to be able to both retrieve items having a specific value of the key, and find its maximum value by querying and requesting a single item in inverse sorting order. When I try to…
Isac Casapu
  • 1,163
  • 13
  • 21
1
vote
1 answer

Does DynamoDB GSI overloading give performance benefits or just flexibility

Does GSI Overloading provide any performance benefits, e.g. by allowing cached partition keys to be more efficiently routed? Or is it mostly about preventing you from running out of GSIs? Or maybe opening up other query patterns that might not be so…
Martin Bayly
  • 2,413
  • 3
  • 19
  • 19
1
vote
1 answer

Executing DynamoDB queries in parallel (BatchGetItems for Global Secondary Index)

The idea here is run multiple DynamoDB queries in parallel as the query is run over a GSI. As of now BatchGetItems doesn't support querying over Indexes and the recommended approach is to Query the data in parallel. I'm using go routines with wg to…
user2967920
  • 469
  • 1
  • 8
  • 22
1
vote
1 answer

DynamoDB query using secondary index, how to query with different keys

i'm using serverless framework with dynamodb [in Local]. trying to query with secondary indexed fields. goal is to query with few keys like we do in basic find queries in Mongo: {url:''} or may be like this…
Saikat Chakrabortty
  • 2,520
  • 4
  • 22
  • 39
1
vote
2 answers

Amazon DynamoDB set index strategy

I am just starting working in dynamodb and I want to set some indexes correctly. I have a table with objects with the following fields: id -> unique id for every object businessType -> not unique, you can have multiple objects with the same business…
Michael G
  • 13
  • 4
1
vote
1 answer

DynamoDB Global Secondary Index creation has stalled

I have tried to create a Global Secondary Index on my DynamoDB table that has approximately 600k records in it. After several hours of indexing, the OnlineIndexPercentageProgress metric seems to have stalled at 61% and has been stuck there for…
eczajk
  • 447
  • 4
  • 15
1
vote
1 answer

Weird result when querying a dynamodb GSI with a non-existent start key. Bug or feature?

I'm querying a global secondary index with a start key that does not exist and I'm seeing some weird results. Is this a ddb bug or (un?)documented behavior? Are there workarounds? I have a table with the primary hashKey being "id" and the…
Cory Mawhorter
  • 1,583
  • 18
  • 22
0
votes
1 answer

DynamoDB Query with partition key and sort key giving me Query condition missed key schema element error

I'm using boto3 in Python to make queries to a DynamoDB. I'm using a Local Secondary Index to query my results sorting by an attribute (start_date). However, when connecting two Key( ) elements with &, it gives me an error, even though the first…
Luigi Trevisan
  • 1
  • 1
0
votes
1 answer

Lambda writing CSV records into Dynamo Table does not completely write all records to that table

I have written a python Lambda module that uses a manifest for writing csv file records to the Dynamo table. An external SA integration loads both the manifest file and the CSV files into an S3 bucket (The csv file names and their record sizes are…
Anthony Williams
  • 55
  • 7
0
votes
1 answer

DynamoDB Single Table many to many to many

I have a data relationship of many Users to many Roles to many Permissions. The Users to Roles many to many relationship is handled in a single table using different indexes to represent which side of the many to many relationship you are on. I am…
Warren
  • 735
  • 7
  • 19
0
votes
2 answers

How can I efficiently query DynamoDB for a start- and end-date between a given date?

I have a table with campaigns and multiple windows for every campaign with a start and end…
KevinVRansbeeck
  • 1
  • 1
1 2 3
…
16 17