Is it possible to search for records in RIAK based on time intervals? Such as pulling out the most recent records for the past 7 days.
Ie, from MySQL:
WHERE DATE(edit_date) = DATE_SUB(CURDATE(), INTERVAL 7 DAY)
Asked
Active
Viewed 34 times
1 Answers
0
You should use a 2i index to record the edit time for each record. Add these as UNIX timestamps. Then it's simple to query between two integers when looking up records.
mafrosis
- 2,720
- 1
- 25
- 34
-
Thanks. Tested this and it works. Use a RANGE 2i search. – revert Sep 26 '14 at 01:35
-
Yup. The actual syntax will vary depending what library you're using to connect to Riak. – mafrosis Sep 26 '14 at 02:41