如何在MongoDB中的长时间戳上创建TTL索引 [英] How to create TTL Index on long timestamp in MongoDB
问题描述
在我的mongo数据库中,我具有字段时间戳,该字段将创建时间保存在时间戳中,即:"timestamp": 1544029233021
我想在此字段上创建TTL索引,但是在docs示例中是在"createdAt": new Date(),
(即ISODate("2018-12-13T17:00:10.433Z")
In my mongo database I have field timestamp which holds time of creation in timestamp ie: "timestamp": 1544029233021
I want to create TTL index on this field, but in docs example is done on "createdAt": new Date(),
which is ISODate("2018-12-13T17:00:10.433Z")
是否可以使TTL索引在时间戳字段上正常工作?
Is it possible to in any way to make TTL Index work on timestamp field?
因为这不起作用:
db.coll.createIndex( { "timestamp": 1 }, { expireAfterSeconds: 3600 } )
推荐答案
文档未过期,因为timestamp
值为整数.
The documents aren't being expired because the timestamp
value is an integer.
TTL索引仅适用于索引字段为日期或包含日期数组的文档:
TTL indexes will only work on documents where the indexed field is a Date or holds an array of Dates:
如果文档中的索引字段不是日期或不是 拥有日期值,文档将不会过期.
If the indexed field in a document is not a date or an array that holds a date value(s), the document will not expire.
( https://docs.mongodb.com /manual/core/index-ttl/#expiration-of-data )
这篇关于如何在MongoDB中的长时间戳上创建TTL索引的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!