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.

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ