Stack Overflow
Stack Overflow

Questions tagged [amazon-dynamodb-index]

251 questions
2
votes
2 answers

How to stop the current Index creation Operation in DynamoDB?

I am try to add an index in DynamoDB table having size around 200MB. its took almost 15 hours and is still running. I have checked that i have given the low read/write IOPS for index. Now i want to increase IOPS and restart the index creation…
Aman Aggarwal
  • 17,619
  • 9
  • 53
  • 81
1
vote
0 answers

DynamoDB not picking record, if item is added while processing

I am reading DynamoDB item as a page Size of 10. There is one use case where, the records can be added in DynamoDB while processing DynamoDB. As, we know that the pointer takes care of last Record Read, but suppose if record is added where pointer…
Prathviraj Singh Chouhan
  • 43
  • 1
  • 8
1
vote
1 answer

DynamoDB two Global Secondary Indexes with the same hash key order by a specific sort key

I have a DynamoDB table with two GSI: GSI 1 hash key: studentGroup sort key: mathScore GSI 2 hash key: studentGroup sort key: scienceScore When I scan the table with filter studentGroup = 1, does DynamoDB return the results in the order of…
Chienwen
  • 11
  • 2
1
vote
2 answers

DynamoDb givies error "Filter Expression can only contain non-primary key attributes"

I am using dynamoDb via dynamoose and trying to use filtering and sorting. I had secondary Index as Partition key (Organization id) and sort key as (First name). I want to sort with same column as well wants to filter with same column, I am using…
Prafful Panwar
  • 11
  • 1
1
vote
1 answer

DynamoDB throughput doubled for GSI

I have an application running in AWS and using DynamoDB (among other things). I have a table that is fairly highly used that I'm looking at optimizing and I noticed something I don't understand. The table has 4 GSI's as well as the main table. …
sfaust
  • 2,089
  • 28
  • 54
1
vote
1 answer

How to get group by and count of millions of records in fastest way in dynamodb

So I have below rows in DynamoDB with example data. I want to find out the count in below format. Currently I am doing query and pagination to achieve this but its terribly slow due to huge number of rows in millions. Is there any other faster way…
ghostrider
  • 2,046
  • 3
  • 23
  • 46
1
vote
2 answers

How to create an item with an index in DynamoDB?

I have been looking everywhere on AWS docs for any information on this and can find absolutely none. The only answer I keep getting everywhere I look is how to query or scan using a secondary index, on already-indexed data. But how do you add a…
henry brown
  • 11
  • 2
1
vote
1 answer

Get all items of the last 15 minutes in DynamoDB

As I come from RDBM background I am bit confuse with DynamoDB, how to write this query. Problem : need to filter out those data which is more than 15 minutes. I have created GSI with hashkeymaterialType and createTime (create time format…
Yashika Chandra
  • 163
  • 3
  • 13
1
vote
0 answers

DynamoDb Between Query always returns null

I'm trying to return the results where a row is equal to the first attribute, and falls between a date range for the second attribute. This always returns no results, even though I can see valid results in the table. I can't find a lot of…
Nicole Kurtz
  • 11
  • 2
1
vote
2 answers

How the partition limit of DynamoDB works for small databases?

I have read that a single partition of DynamoDB has a size limit of 10GB. This means if all my data are smaller as 10GB then I have only one partition? There is also a limit of 3000 RCUs or 1000 WCUs on a single partition. This means this is also…
Horcrux7
  • 23,758
  • 21
  • 98
  • 156
1
vote
1 answer

Query GSI in DynamoDb with a substring of the key (begins_with)

Let's take the best practices for sort keys official documentation of DynamoDb as an example: https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-sort-keys.html Imagine we have a table like the documentation mentions, where our sort…
Borja Sanchidrián Monge
  • 189
  • 9
1
vote
1 answer

PynamoDB Error for Local Secondary Index: ValueError('Table table_4 has no index: key1_index',)

I am new to pynamodb and I'm trying to query on LSI (already defined in dynamodb main table) and getting the following Exception. 'exception': ValueError('Table table_4 has no index: key1_index',) UseCase: i wanted to query on LSI on hash_key only,…
Ananya Verma
  • 63
  • 5
1
vote
1 answer

Is it possible to create auto-inceremented partition key on cloud formation?

I need to create a cloudformation template for my dynamodb, but I need one of the indexes to be incremented automatically. CloudFormation template looks like this: TestTable: Type: AWS::DynamoDB::Table Properties: TableName:…
PurpleGreen
  • 39
  • 8
1
vote
0 answers

ValidationException: Variable reference created_at in ORDER BY clause must be part of the primary key

I created a table in DynamoDB. I want to get List of entity with username (local-secondary-index) and order by created_at. When I tried in PartiQL this query. SELECT * FROM "user-wallet-stage"."LSI_username" WHERE "username" = 'username' order by…
more
  • 183
  • 1
  • 7
  • 18
1
vote
1 answer

Can we update the Projection of existing Global Secondary index of a DynamoDB table?

Can we update the Projection of existing Global Secondary index of a DynamoDB table ? I want to update the projection to ALL so save the redundant call to partition key.
pritampanhale
  • 106
  • 10
1 2 3
…
16 17