Stack Overflow
Stack Overflow

Questions tagged [dynamodb-queries]

Use when content is about querying or scanning Amazon DynamoDB managed database.

1232 questions
0
votes
1 answer

How to get all data of table and apply if condition dynamodb

I am looking into this documentation http://boto3.readthedocs.io/en/latest/reference/services/dynamodb.html there is get_item function to get a specific element but I want to get all data of this table . Is there any way to get all table data ?…
Pro-Web
  • 31
  • 1
  • 11
0
votes
0 answers

How to create index table for order by in DynamoDB AWS

I want to store the information of user and their total_score. Each user has a facebook_id and it will be the primary key. I designed the table and index like that: Table name: UserDataTest Primary partition key: facebook_id (String) Now I want…
TccHtnn
  • 916
  • 2
  • 8
  • 12
0
votes
1 answer

Deal with I/O capacities in dynamodb

We are using the dynogels library to query a dynamoDB table. Unfortunately, as dynamoDB do not have a pagination feature, for a specific need, we are retrieving all data from the table through a loadAll to get all items of the table (18K items) and…
romain-nio
  • 1,183
  • 9
  • 25
0
votes
0 answers

DynamoDB Query to return multiple items

I am having a problem to solve this issue in DynamoDB. I need to create a table of sellers and their location expressed as Long and Lat attributes. Now if I have a Buyer. I need to return all sellers within 1 Mile radius of the buyer. How do I…
Bluetoba
  • 885
  • 1
  • 9
  • 16
0
votes
1 answer

DynamoDB query returns zero results

I'm trying to query a DynamoDB table to find a product based on it's url. The table has three fields: Title, Description & Url. var credentials = new BasicAWSCredentials(awsDBLogins.AccessKey, awsDBLogins.SecretKey); var client = new…
TidyDev
  • 3,470
  • 9
  • 29
  • 51
0
votes
1 answer

DynamoDb querying Enum

I am new to dynamoDB and this question might be juvenile. I am trying to query an item from the table but dynamo api is not able to convert the query json result into the class instance because there is an enum variable member present in the…
santhosh kumar
  • 1,981
  • 1
  • 9
  • 28
0
votes
2 answers

Performing a conditional expression query on GSI in dynamodb

I know the query below is not supported in DynamoDB since you must use an equality expression on the HASH key. query({ TableName, IndexName, KeyConditionExpression: 'purchases >= :p', ExpressionAttributeValues: { ':p': 6 } }); How…
Daniel Kobe
  • 9,376
  • 15
  • 62
  • 109
-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
0 answers

Reflecting a change in a user's username across all of that user's posts with DynamoDB

I'm running into an issue thinking about how I should design my Dynamo table to account for the case where a user with posts wants to change their username (display name), and that now all of the posts should render the updated username. For…
becks
  • 9
  • 5
-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
1 answer

Check an attribute exists or not inside an object in DynamoDB

I like to fetch records which has null value of an attribute, the problem is this attribute exists inside another attribute am trying to do it via aws console i tried with contains and not contains didn't work, am attaching my structure here { …
Kannan T
  • 1,639
  • 5
  • 18
  • 29
-1
votes
1 answer

Better understanding DyamoDB compound sort keys

I'm trying to understand how use compound sort keys as discussed in this video. I understand the concept of chaining values together in this key to make querying for data more efficient, but I don't understand implementing it yet in the context of…
Zach Kaigler
  • 279
  • 5
  • 15
-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

Internal working of DynamoDB while Querying

How does read query works in dynamoDB? I know that it internally calculates the hash based on the partition key and finds out the in which partition the item is present. After finding the partition how do you find the specific location of the…
umamahesh bodanapu
  • 11
  • 1
-1
votes
1 answer

Query Dynamo DB with multiple columns using AWS SDK V3 and Typescript

I have the below piece of code that I try to use to fetch a row of data using values for 3 columns. const client = new DynamoDB({region: "us-east-1"}); const params = { TableName: Tables.TYPES, ExpressionAttributeNames: { '#type': "type", …
AnOldSoul
  • 4,017
  • 12
  • 57
  • 118
1 2 3
…
82 83