How to retrieve distinct temperature values (like distinct sql statement) ? (assuming some row have the same temperature value). Is is possible to use GSI / LSI (or a second table may be ) for that ? I can only achieve it by scanning the whole table and filter results (.distinct() ) once the request is done (which is extremely expensive) ... Is it possible to do it in a more efficient way with GSI / LSI ? Thx
@awssupport
6 ай бұрын
Hello, 😀 this is a great question for our community of experts on re:Post! You can ask for additional technical insight to this, and also browse other topics and use cases: go.aws/aws-repost. There are also more options to find help, listed here: go.aws/get-help. 🤝 ^AD
@marcelofm80
Жыл бұрын
is the table shown on time 2:05 wrong? I would expect the Device to be the same, either 1 or 2 for both rows kzitem.info/news/bejne/o6F722uwe4mYmG0
@awssupport
Жыл бұрын
Hi Marcelo, your question is acknowledged! 🔎 I have passed along internally your concern to the appropriate team. Any feedback they have will be communicated back to you. We want nothing but the best, as you continue your AWS path! 🥾 ^DC
@awssupport
Жыл бұрын
Hey Marcelo! Our DynamoDB team had some insight to share: "In the previous table at 1:55 for example, you had two different devices. In this example, only two of those elements have the Attribute ErrorStatus. If you select in either a GSI or LSI ErrorStatus as the Sort Key, your view will look like the one shown at 2:05. GSI and LSI are sparse, which means you only will populate the items that contain the right Partition and sort key combination. In this case, all the other elements that do not contain the Attribute ErrorStatus will not be present in the Index, giving you the result as shown." I hope this clears up any questions, but feel free to reach out to our DynamoDB team directly with any feedback on this video, here: go.aws/feedback. You can also check out our other options for help: go.aws/get-help. ^RM
Пікірлер: 10