Questions tagged [amazon-dynamodb-index]
251 questions
-1
votes
0 answers
DynamoDB Lock on multiple rows
I have a table in dynamoDB which has fields like customerId, mobileNumber, status
customerId - Primary/partition key
mobileNumber - GSI and doesn't have unique values
status - sort/range key with only two value ACTIVE, INACTIVE
customerId -…
suraj katiyar
- 9
- 3
-1
votes
2 answers
Query dynamoDB based on HASH key only efficiently and cost effectively
I have a dynamoDB table with a HASH key and a SORT key.
**Now I have a situation where I need to get table contents based on the HASH key only and it will return an array of items. **
I am able to do this with .query() operation
const params =…
Asif Alam
- 11
- 3
-1
votes
2 answers
Do I need to include Key attributes of all Global Secondary Indices when doing UpdateItem in DynamoDB?
I have a table with these columns:
subscription_id
email
order_id
updated_at
note
and two secondary indices attached to it. 1 index is using Key field email and another - order_id.
When I do UpdateItem for the table, where I change only note,…
Ribtoks
- 6,634
- 1
- 25
- 37
-1
votes
1 answer
Query key condition not supported in DynamoDB
I'm attempting to set up my DynamoDB table so I can query the data via a rest API. My table has a partition key (id) which is a randomly generated ID, a sort key (name) and a List of strings (domain).
I have also set up a global secondary index for…
Kieran Crown
- 307
- 5
- 16
-1
votes
1 answer
Is it possible to create GSI on 2billion items in DynamoDB
Is it possible to create 2 Global Secondary Index in DynamoDB table which has 2Billion items in it.
What would be the time consumed to create these indexes
Prateek
- 35
- 1
- 7
-1
votes
1 answer
How to query with multiple conditions, limit and order by in DynamoDB?
So I have a table with the following data:
id business_id credit name owes partner_id type_id updated
45b4bvfdghfghbdgfgfhbdfghbdbbfg 435634652 0 FORL 55 69992528 3 …
showtime
- 1
- 1
- 17
- 48
-1
votes
1 answer
How to ORDER BY a query in DynamoDB using PartiQL?
There are some answers in some forums about this question where people are generally repeating the already confusing AWS documentation about DynamoDB, but I need an example to see how it actually works.
I have this query :
SELECT id, message,…
showtime
- 1
- 1
- 17
- 48
-1
votes
1 answer
Get data based on sort index AWS dynamoDB
I have a DynamoDB table like this:
I want to list all posts irrespective of users, i-e by getting all data whose sort key is "post". How can I achieve this?
I have heard about Global Secondary Index, but couldn't figure out how to use them.
plutolaser
- 448
- 4
- 17
-1
votes
1 answer
Get multiple records from a dynamo db table using Global Secondary Index
I have a dynamo db table CustomerOrders with following fields
Primary partition key: CustomerId (Number)
Primary sort key: DepartmentId (Number)
Order (Serialized Json String)
I would like to do a query on multiple customers in one request without…
user007
- 1,504
- 2
- 18
- 51
-1
votes
1 answer
Query DynamoDB by GSI using AppSync SDK and Amplify CLI
I'm trying to query a DynamoDB table through AWS AppSync, using AWS'
Android AppSync SDK, and the Amplify CLI. I'm querying a Global
Secondary Index (GSI). I'm getting an error:
Expression block '$[query]' requires an expression
I've found a…
awenclaw
- 373
- 5
- 20
-1
votes
1 answer
Query DynamoDB table attributes using an AND and WHERE like statement
I have a flat table with around 30 attributes in DynamoDB. I would like to expose an API for my end users/applications to query on a random combination of those attributes.
This is trivial to do in a typical RDBMS.
How can we do this in DynamoDB?…
gudvred
- 1
- 3