asterixdb-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Jacobs (JIRA)" <>
Subject [jira] [Commented] (ASTERIXDB-1606) Optimize "last value" query
Date Tue, 23 Aug 2016 21:33:21 GMT


Steven Jacobs commented on ASTERIXDB-1606:

This will be great to have in master. What are your thoughts on (1)?

> Optimize "last value" query
> ---------------------------
>                 Key: ASTERIXDB-1606
>                 URL:
>             Project: Apache AsterixDB
>          Issue Type: Bug
>            Reporter: Steven Jacobs
>            Priority: Minor
> We need to work on optimizing queries looking for a "most recent" or "greatest" value
of a given field. 
> As an example, consider an append-only dataset filled with user locations over time,
and suppose we want to know the user's last known location. Currently, we would need to do
this as an:
> order by $record.timeStamp
> limit 1
> We could improve this in two ways:
> 1) Improve usability by providing an alias syntax for users, e.g. "where greatest timeStamp"
> 2) Improve the compilation of such a job to only retrieve a single record.

This message was sent by Atlassian JIRA

View raw message