DynamoDB, TTL not deleting items

0

I set up TTL to delete an item called "epoch" with is just the epoch time casted to an integer. I set up TTL 2 weeks ago, and nothing has been deleted yet. I tried the preview with "payload.epoch" as well, just to check, and no dice. Here is what a JSON entry looks like:

{
 "timestamp": "2022-01-26 13:00:30.676968",
 "payload": {
  "air_flow": 1.5,
  "rssi": -93,
  "temp": 19.09,
  "data": "03d10775018f0a006ff3",
  "rx_freq": 929000000,
  "humidity": 28.659,
  "epoch": 1643230830,
  "ep": 1,
  "pressure": 102154,
  "seq": 71,
  "timestamp": "2022-01-26 13:00:30.676968"
 }
}
Ian
已提问 2 年前1066 查看次数
1 回答
2
已接受的回答

You must set your TTL attribute as a top level attribute. You cannot have it inside a map:

{
 "timestamp": "2022-01-26 13:00:30.676968",
 "epoch": 1643230830,
 "payload": {
  "air_flow": 1.5,
  "rssi": -93,
  "temp": 19.09,
  "data": "03d10775018f0a006ff3",
  "rx_freq": 929000000,
  "humidity": 28.659,
  "ep": 1,
  "pressure": 102154,
  "seq": 71,
  "timestamp": "2022-01-26 13:00:30.676968"
 }
}
profile pictureAWS
专家
已回答 2 年前
profile picture
专家
已审核 1 个月前
  • I made another table, and used epoch as the primary key instead, it did not delete in the preview. I also made it an item in the top level, along side the primary key, it doesn't delete.

  • You are aware it can take 48 hours. Please provide more details on your table:

    • The output of: aws dynamodb describe-time-to-live --table-name <your table name>

    • A sample item which you expected to have been evicted, including the time it was inserted to the table.

  • output: { "TimeToLiveDescription": { "TimeToLiveStatus": "ENABLED", "AttributeName": "epoch" } } I am aware of the 48 hour period. I was using the "run preview" feature to see what would be deleted in a week, and there are no results in the query.

  • Don't use the preview...it doesn't seem to work

  • I encourage you to use the feedback button in the console, it will alert the team responsible for the preview feature.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则