Is there a way to query by last-update-time (LUT)?


#1

I want to get all the records which have been updated after a specific time. Will I have to maintain a bin ‘last_updated’? Or is there a way to utilise last-update-time from metadata?


#2

Very soon :slight_smile: . I believe it will appear in the next release.


#3

And when is the next release due?


#4

Major releases come out roughly every quarter, see release notes. So the next major release should be in April.


#5

@kporter I believe this feature is released now? How do I use the last-update-time while querying?


#6

The solution is to use predicate filtering, an example using last update time can be found here:


#7

@kporter Thanks. Is there an equivalent term for aql? (I checked aql - Querying records docs, but it isn’t clear.)

EDIT: Or in Python? I couldn’t find docs for that too. :confused:


#8

AQL doesn’t have that ability right now. It’s a tool for (sort of) browsing data and administration of indexes, UDF registration, users/roles. It’s not intended for you to write applications with - that’s what those language clients are for.


#9

Yes, I understand. This is not really for writing an application.

I want to check how much of “old” data we have in a particular set, so we can decide the appropriate archival/deletion strategy.

If not AQL, I can work with the Python client too. Could you please point me to the “query by LUT” docs for python? I’m unable to find it for Python.


#10

Aerospike Team,

Do we have any update on this? Even I’m in need of this.


#11

Python and aql still do not support predicate filters. I know Java and C support this feature.

@jan, @khosrow, what is the status for other clients?


#12

Go does support predicate filters.


#13

Check out the Client Feature Matrix: Currently only the clients already mentioned (Java, C/C++, Go) as well as the C# client support Predicate Filters.


#14

Any chances of this supported in aql?


#15