Use when content is about querying or scanning Amazon DynamoDB managed database.
Questions tagged [dynamodb-queries]
1232 questions
-1
votes
2 answers
Is there a way to efficiently fetch all the results from a medium sized DynamoDB?
I'm using boto3 with python, but I belive the problem and logic should be universal across all languages.
I know that table.scan() should in theory return all the records, but in fact, they scan() results are limited to 1MB in size. It's recommended…
madej
- 49
- 1
- 7
-1
votes
1 answer
Which is correct method with respect to performance for bulk data . Scan or query. To get all the table data in DynamoDB
I want to get all the items from table. Is query with GSI faster than scan ?
I see Scan has parallel scan option but I don’t know how to implement it .
If I go with query with GSI . Do I don’t need to worry about performance issues?
Please let me…
vrk
- 5
- 3
-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
-1
votes
1 answer
Designing dynamoDB table
I am creating new service which will expose APIs. These APIs are adding entries to dynamo table. I have below requirements. accordingly I need to create new table.
As a end-user, I need to add userIds to groups (Each group has unique id).
As a…
Kav
- 11
- 2
-1
votes
1 answer
How do I query the range of a GSI of any item in DynamoDB (i.e. not partition key dependent)?
I am using Node.js with DynamoDB. I want to fetch the items in the table that are from the past month. I have a date GSI and the id is also linked to the date. I don't want to use scan because this table will grow. The main issue is that it is not…
Daniel Edwards
- 81
- 1
- 10
-1
votes
1 answer
Linking S3 bucket to DynamoDB using AWS Lambda
Currently struggling to link my S3 bucket to my DynamoDB using the AWS Lambda function in Python 2.7.
Completely new to AWS so any help is appreciated. I've looked at various online tutorials but none of them seem to work, the file format I want to…
JMillward23
- 93
- 1
- 1
- 4
-2
votes
1 answer
Somehow my FilterExpression does not working AWS Lambda and DynamoDB
Here is my code snipped that retrieves data from customer-event-logs dynamoDB table with customer_id parameter from /events endpoint.
elif path == '/events':
# Handle the /events endpoint logic here
request_json = event['body']
…
-2
votes
1 answer
Query DynamoDB with "where" and "between" at once
I'm very new to DynamoDB, in SQL we could have done the below:
select * from Table where Section = 10 and Percentage between "90" and "100"
Need to the same with DynamoDB using Python Filter Expression. Below is the query which I have written.
fe =…
user19540656
-2
votes
1 answer
How to query over sort key in the simplest manner?
I have a table stored in dynamoDB which exemplary dictionary is the following:
{event': 'A',
'timestamp': '2017-10-15 16:20:47,009',
'message': 'AAA'},
{event': 'B',
'timestamp': '2018-10-15 16:20:47,009',
'message': 'BBB'},
{event':…
John
- 1,849
- 2
- 13
- 23
-2
votes
1 answer
Fixing data issues in Dynamodb
we are in a bit of a pickle with our dynamodb data. We have a dynamodb table with millions of records currently in use in production. Transaction data was loaded into this dynamodb table by a nightly injestion process. Unfortunately, when the…
user1657861
- 271
- 3
- 14
-2
votes
1 answer
DynamoDb Query using Between operator on Primary(Partition) Key only
I have a Dynamo table in which I have partition key only - "CreatedAt" and some other attributes.
I want to write a Query in which I will get no. of items where CreatedAt is between LastSunday and Today.
I have stored the date in string format as…
karan chavan
- 215
- 2
- 12
-2
votes
2 answers
Lost with dynamodb table definition
I'm a little lost with dynamodb table definition and Keyschema. Here's what i want to achieve :
I'm creating a table to store reporting information. This reporting will be in the folliwing format :
itemId, accountId, date, typeOfMetric, metric1,…
Tibo
- 621
- 1
- 8
- 24
-2
votes
1 answer
Is there an AWS service that provides <= 20 milliseconds query latency?
For a use-case, my team is using DynamoDB to query a GSI. With increasing number of rows returned, the query latency increases.
Our code looks something like this (Java) (pretty normal)
Map keyConditions = new…
Anusha
- 337
- 2
- 4
- 21
-3
votes
1 answer
Import a very large txt file to Dynamobd
I have a huge txt file and I need to put it on DynamoDB.
the file struct is:
223344|blue and orange|Red|16/12/2022
223344|blue and orange|Red|16/12/2022
...
This file has more than 200M lines
I have tried to convert it on json file using this code…
Roger Monteiro
- 1
- 2
-3
votes
1 answer
javascript map function for objects multi level
How can I loop through all the entries in an array using JavaScript? , javascript map function for objects multi level
Example
const myObject = [
{
'name' : {'s': 'name1'},
'surname' : {'s': 'surname1'},
'tel' : {'n': 2223456789}
…
Poh st'john
- 3
- 1