amazon-dynamodb - DynamoDB降序读取记录

Question

我收集了100条记录，

集合名称:“用户”

{
   "name":'senthilkumar',  
   "email":'senthily88@gmail.com',  //HashKey
   "age":21,
   "created":1465733486137,         //RangeKey-timestamp
}

我需要获取以下SQL查询明智的记录

select * from users order by created desc limit 10

我如何从 DynamoDB 中获取上述查询格式记录

Answer 1

Dynamodb按范围键属性对结果进行排序。您可以将ScanIndexForward bool(boolean) 参数设置为true升序或false降序。

资源:http://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Query.html

Use the KeyConditionExpression parameter to provide a specific value for the partition key. The Query operation will return all of the items from the table or index with that partition key value. You can optionally narrow the scope of the Query operation by specifying a sort key value and a comparison operator in KeyConditionExpression. You can use the ScanIndexForward parameter to get results in forward or reverse order, by sort key.