Good video, but I don’t quite understand how query lookup is O(1). How is that possible if we are searching the table for the matches to our query? Isn’t it based on the size of our table, so O(n) or larger?
Nice video. Question: How should be format the datetime for using query with between? dd:mm:yyyy hh:mm:ss? Or do we need to separate date and time? Any suggestions about querying dt columns.
Personally, I convert DateTimes to Unix timestamps. 28:10:2021 20:00:00 => 1635447600. You can then query for values less than, greater than, or between the dates.
Very nice video! Very educational. What if in my Customer Order table I have other fields like "Country" and "Product Type" and I want to filter, for example, "Tech" products bought in the "US". How will I query or fetch that data?
Can you do operations like give me all customers with id greater than 1 on the partition key? Or are you limited to one value for the partition key for each query?
Hi Moneesh, I don't know of any built-in method to do this beyond using multiple threads and firing off separate queries. There's a good article on this topic by AWS here: aws.amazon.com/blogs/database/use-parallelism-to-optimize-querying-large-amounts-of-data-in-amazon-dynamodb/ Hope this helps
Great video, dude! In my case, I'm using PK , but I have others 3 GSIs. The behavior is the same using GSI and his sort key comparing with PK + his sort key? thanks in advance!
In my case i want to scan all data each time to compare with my response to know where update occur or insert and according to that i want to perform other requests...so what could be the best possible way?
Excellent video! The release of your video is fortuitous - I am studying for my first AWS certification and just completed a dynamoDB lab the other night. However none of these subtleties you described were highlighted. Thanks for providing your insights. 👍
Really good content! Well presented! No annoying background music. No annoying intro to the channel. No "Hey what's up guys". No strange accent; Just good, plain English.