new RangeQuery()
Builder for queries that select a range of events from a time series.
See Session.timeseries for an overview of the various types of range query:
- value range queries,
- latest edits edit range queries, and
- all edits edit range queries.
Session.timeseries#rangeQuery returns a default RangeQuery. Further queries with different parameters can be configured using the methods of this interface. RangeQuery instances are immutable. Each method returns a copy of this query with a modified setting. Method calls can be chained together in a fluent manner to create a query. For example:
var defaultQuery = session.timeseries.rangeQuery(); // A value range query that selects up to 100 original events from the // start of a time series. first100 = defaultQuery.forValues().fromStart().next(100);
Creating value range queries
A value range query returns a merged view of part of a time series. This is the most common time series query and appropriate for most applications.
A value range query begins with the RangeQuery#forValues operator,
followed by the view range. The view range determines the range
of original events the time series that are of interest. See Range
expressions below for the various ways to specify RANGE
.
The events returned by the query are constrained by an optional edit range, introduced by the RangeQuery#editRange() operator. An event will only be included in the result if it is in the edit range. Let's consider some examples to see how the view range and the edit range interact.
Query | Meaning |
---|---|
rangeQuery().forValues(); |
For each original event in the time series, either return the latest edit event or if it has no edit events, return the original event. |
rangeQuery().forValues().from(100).to(150); |
For each original event with a sequence number between 100 and 150 (inclusive), either return the latest edit event or if it has no edit events, return the original event. |
rangeQuery().forValues().from(100).to(150).editRange().from(400);
|
For each original event with a sequence number between 100 and 150
(inclusive), return the latest edit event with a sequence number greater
than or equal to 400.
The result of this query will not include any original events because there is no overlap between the view range and the edit range. |
Value range queries can be further refined using the limit() and as() operators.
Creating edit range queries
An edit range query returns an unmerged view of a time series than can include both original events and the edit events that replace them. Edit range queries are rarely needed – value range queries satisfy most use cases.
An edit range query begins with the RangeQuery#forEdits() operator,
followed by the view range. The view range determines the range
of original events the time series that are of interest. The result will
only contain original events that are in the view range, and edit events
for original events in the view range. See Range expressions
below for the various ways to specify RANGE
.
The events returned by the query are constrained by an optional edit range, introduced by the RangeQuery#latestEdits() or RangeQuery#allEdits() operators. An event will only be included in the result if it is in the edit range. Let's consider some example edit range queries.
Query | Meaning |
---|---|
rangeQuery().forEdits(); |
Return all events in a time series. |
rangeQuery().forEdits().from(100).to(150); |
Return the original events with a sequence number between 100 and 150 (inclusive) and all edit events in the time series that refer to the original events. |
rangeQuery().forEdits().from(100).to(150).latestEdits(); |
Return the original events with a sequence number between 100 and 150 (inclusive) and the latest edit events in the time series that refer to the original events. |
rangeQuery().forEdits().from(100).to(150).allEdits().from(400);
|
For each original event with a sequence number between 100 and 150,
(inclusive) return all edit events with a sequence number greater than or
equal to 400.
The result of this query will not include any original events because there is no overlap between the view range and the edit range. |
Edit range queries can be further refined using the limit() and as() operators.
Range expressions
Range expressions are used to specify the view and edit ranges in value range and edit range queries. Each range expression has an anchor that determines where to start, and a span that determines where the range ends. Both anchor and span are inclusive – if an anchor or span falls on an event, the event is included in the result.
Both anchor and the span are optional. If the anchor is unspecified, the range begins at the start of the time series. If the span is unspecified, the range continues until the end of the time series.
Anchors
There are five ways to specify an anchor.
Anchor | Meaning |
---|---|
from(Number) | Sets the anchor at an absolute sequence number. |
from(Date) | Sets the anchor at an absolute time. |
fromStart | Sets the anchor at the start of the time series. |
fromLast(Number) | Sets the anchor at a relative offset before the end of the time
series. For value range queries, count is the number of original
events. For edit range queries, count is the number of events of
any type. |
fromLast(Date fromLastMillis |
Sets the anchor at a relative time before the timestamp of the last event of the time series. |
An anchor point can be before the start or after the end of the time series.
Spans
There are nine ways to specify a span.
Span | Meaning |
---|---|
to(Number) | The range ends at an absolute sequence number. The sequence
argument may be before or after the anchor. |
toStart | The range ends at the start of the time series. |
to(Date) | The range ends at an absolute time. The date argument may
be before or after the anchor. |
next(Number) | The range ends at an event that is a relative number of events after
the anchor. For value range queries, count is the number of
original events. For edit range queries, count is the number of
events of any type. |
next(Date) nextMillis |
The range ends at an event that is a relative time after the anchor. |
previous(Number) | The range ends at an event that is a relative number of events before
the anchor. For value range queries, count is the number of
original events. For edit range queries, count is the number of
events of any type. |
previous(Date) previousMillis |
The range ends at an event that is a relative time before the anchor. |
untilLast(Number | The range ends at an event that is a relative number of events before
the end of the time series. For value range queries, count is the
number of original events. For edit range queries, count is the
number of events of any type. |
RangeQuery#untilLast(Date) untilLastMillis |
The range ends at an event that is a relative time before the timestamp of the last event of the time series. |
A span can specify an end point that is before the start or after the end of the time series.
If the span specifies an end point after the anchor, the range includes the first event at or following the anchor and ends at the last event at or preceding the end point. If the span specifies an end point before the anchor, the range includes the first event at or preceding the anchor and ends at the last event at or after the end point.
Using the builder methods
Although the natural order of operators in a query is as shown in the syntax diagrams above, RangeQuery builder methods – those that return another RangeQuery – can be applied in any order with the following exceptions:
- RangeQuery#editRange only applies to value range queries, so cannot
follow
forEdits()
without an interveningforValues();
- RangeQuery#latestEdits and RangeQuery#allEdits only apply
to edit range queries, so cannot follow
forValues()
without an interveningforEdits()
.
Each method overrides some configuration of the RangeQuery to which it is applied, as summarized in the following table.
Builder method | Operator type | Overridden configuration |
---|---|---|
forValues() |
Value range | Overrides the existing query type to create a new value range query. Overrides the existing view range with a new view range that selects the entire time series. The existing edit range is copied unchanged. |
forEdits() |
Value range | Overrides the existing query type to create a new edit range query that includes all edits. Overrides the existing view range with a new view range that selects the entire time series. The existing edit range is copied unchanged. |
editRange()
| Edit range | Overrides the existing edit range with a new edit range that selects
the entire time series. The existing view range is copied unchanged. Throws IllegalStateException if this is not a value range
query. |
latestEdits() allEdits() |
Edit range | Overrides the existing edit range with a new edit range that selects
the entire time series. The existing view range is copied unchanged.
Throws Error if this is not an edit range query. |
from() fromStart() fromLast() |
Anchor | Overrides the anchor of the current range. |
to() toStart() next() previous() untilLast() |
Span | Overrides the span of the current range. |
limit() |
Limit | Overrides the limit. |
as() |
Query value type | Overrides the query value type. |
Methods
-
allEdits()
-
Return a copy of this RangeQuery configured to perform an edit range query with the edit range that selects all edits in the entire time series.
This operator can only be applied to edit range queries. The default query returned by rangeQuery() is a value range query. The RangeQuery#forEdits operator can be used to create an edit range query form a value range query.
Operator type: edit range
Throws:
-
if this is not an edit range query
- Type
- Error
Returns:
a copy of this range query configured to perform an edit range query with a new edit range that selects all edits in the entire time series
- Type
- RangeQuery
-
-
as(valueClass)
-
Return a copy of this RangeQuery with a different query value type.
A query can only be evaluated successfully against time series topics with a compatible event data type. If a query method is called for a time series topic with an incompatible event data type, the query will complete exceptionally.
If the event data type of the time series topic is known, compatibility of a particular
valueClass
can be checked using diffusion.datatypes.DataType#canReadAs. The default range query has a query value type of diffusion.datatypes.Bytes, which is compatible with all time series value data types.Operator type: query value type
Parameters:
Name Type Description valueClass
function | DataType the value class or data type to read event values as
Returns:
a copy of this range query with a new query value type
- Type
- RangeQuery
-
editRange()
-
Return a copy of this RangeQuery configured to perform a value range query with the edit range set to the entire time series.
This operator can only be applied to value range queries. The default query returned by rangeQuery() is a value range query. The RangeQuery#forValues operator can be used to create a value range query from an edit range query.
Operator type: edit range
Throws:
-
if this is not a value range query
- Type
- Error
Returns:
a copy of this range query configured to perform a view range query with a new edit range that selects the entire time series
- Type
- RangeQuery
-
-
forEdits()
-
Return a copy of this RangeQuery configured to perform an edit range query within the view range set to the entire time series.
Operator type: value range
Returns:
a copy of this range query configured to perform an edit range query with a new view range that selects the entire time series
- Type
- RangeQuery
-
forValues()
-
Return a copy of this RangeQuery configured to perform a value range query within the view range set to the entire time series.
Operator type: value range
Returns:
a copy of this range query configured to perform a view range query within a new view range that selects the time time series.
- Type
- RangeQuery
-
from(sequence)
-
Return a copy of this RangeQuery with the anchor of the current range configured to be either an absolute sequence number, or a Date instance.
Operator type: anchor
Parameters:
Name Type Description sequence
Number | Date absolute sequence number or Date specifying the anchor of the returned range
Throws:
-
if sequence is negative
- Type
- Error
Returns:
a copy of this range query with a new anchor
- Type
- RangeQuery
-
-
fromLast(count)
-
Return a copy of this RangeQuery with the anchor of the current range configured to be a relative offset before the end of the time series.
Operator type: anchor
Parameters:
Name Type Description count
Number specifies the anchor as a number of events before the end of the time series. For value range queries, count is the number of original events. For edit range queries, count is the number of events of any type.
Throws:
-
if count is negative
- Type
- Error
Returns:
a copy of this range query with a new anchor
- Type
- RangeQuery
-
-
fromLastMillis(timeSpan)
-
Return a copy of this RangeQuery with the anchor of the current range configured to be a relative time from the timestamp of the last event in the time series.
Operator type: anchor
Parameters:
Name Type Description timeSpan
Number specifies anchor as a number of milliseconds relative to the timestamp of the latest event in the time series
Throws:
-
if timeSpan is negative
- Type
- Error
Returns:
a copy of this range query with a new anchor
- Type
- RangeQuery
-
-
fromStart()
-
Return a copy of this RangeQuery with the anchor of the current range configured to be the start of the time series.
There is a difference between
fromStart( and from(0)
if the range also ends before the first event of the time series. For example,fromStart().toStart()
is always empty, butfrom(0).toStart()
includes the event with sequence number0
.Operator type: anchor
Returns:
a copy of this range query with a new anchor
- Type
- RangeQuery
-
latestEdits()
-
Return a copy of this RangeQuery configured to perform an edit range query with the edit range that selects latest edits in the entire time series.
This operator can only be applied to edit range queries. The default query returned by rangeQuery() is a value range query. The RangeQuery#forEdits() operator can be used to create an edit range query from a value range query.
Operator type: edit range
Throws:
-
if this is not an edit range query
- Type
- Error
Returns:
a copy of this range query configured to perform an edit range query with a new edit range that selects the latest edits in the entire time series
- Type
- RangeQuery
-
-
limit(count)
-
Return a copy of this RangeQuery that returns at most count events.
If the query would otherwise select more than count events, only the latest count values (those with the highest sequence numbers) are returned.
This is most useful when a temporal span has been configured with RangeQuery#nextMillis or RangeQuery#previousMillis, where the potential number of returned events is unknown.
QueryResult#isComplete() can be used to determine whether a query has returned an incomplete result.
Operator type: limit
Parameters:
Name Type Description count
Number the maximum number of events to return
Throws:
-
if count is negative
- Type
- Error
Returns:
a copy of this range query with a new limit
- Type
- RangeQuery
-
-
next(count)
-
Return a copy of this RangeQuery with the span of the current range configured to select a range of events following the anchor.
Operator type: span
Parameters:
Name Type Description count
Number specifies the end of the range of events to select following the anchor. For value range queries, count is the number of original events. For edit range queries, count is the number of events of any type.
Throws:
-
if count is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
-
nextMillis(timeSpan)
-
Return a copy of this RangeQuery with the span of the current range configured to select a temporal range of events following the anchor.
Operator type: span
Parameters:
Name Type Description timeSpan
Number the time span in milliseconds of events following the anchor to select
Throws:
-
if timeSpan is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
-
previous(count)
-
Return a copy of this RangeQuery with the span of the current range configured to select a range of events preceding the anchor.
Operator type: span
Parameters:
Name Type Description count
Number specifies the end of the range of events to select preceding the anchor. For value range queries, count is the number of original events. For edit range queries, count is the number of events of any type.
Throws:
-
if count is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
-
previousMillis(timeSpan)
-
Return a copy of this RangeQuery with the span of the current range configured to select a temporal range of events preceding the anchor.
Operator type: span
Parameters:
Name Type Description timeSpan
Number the time span in milliseconds of events preceding the anchor to select
Throws:
-
if timeSpan is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
-
selectFrom(topicPath)
-
Evaluate this query for a time series topic.
The session must have the
READ_TOPIC
topic permission fortopicPath
to evaluate a query. TheQUERY_OBSOLETE_TIME_SERIES_EVENTS
topic permission is also required if this is an edit range query, or a value range query with an edit range.Parameters:
Name Type Description topicPath
String the path of the time series topic to query
Returns:
a result that completes when a response is received from the server.
If the query returned results, the result will complete successfully and provide an QueryResult.
Otherwise, the result will complete exceptionally with an ErrorReason.
- Type
- Result.<QueryResult, ErrorReason>
-
to(sequence)
-
Return a copy of this RangeQuery with the span of the current range configured to end at an absolute sequence number or Date instance.
Operator type: span
Parameters:
Name Type Description sequence
Number | Date absolute sequence number or Date instance specifying the end of the returned range
Throws:
-
if sequence is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
-
toStart()
-
Return a copy of this RangeQuery with the span of the current range configured to end at the start of the time series.
There is a difference between
toStart()
andto(0)
if the range also starts before the first event of the time series. For example,fromStart().toStart()
is always empty, butfromStart().to(0)
includes the event with sequence number0
.Operator type: span
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
untilLast(count)
-
Return a copy of this RangeQuery with the span of the current range configured to end a number of events before the end of the time series.
Operator type: span
Parameters:
Name Type Description count
Number specifies the end of the range of events to select as a number of events before the end of the time series. For value range queries, count is the number of original events. For edit range queries, count is the number of events of any type.
Throws:
-
if count is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-
-
untilLastMillis(timeSpan)
-
Return a copy of this RangeQuery with the span of the current range configured to end at a relative time from the timestamp of the last event in the time series.
Operator type: span
Parameters:
Name Type Description timeSpan
Number specifies the end of the range of events to select as a number of milliseconds relative to the timestamp of the latest event in the time series
Throws:
-
if timeSpan is negative
- Type
- Error
Returns:
a copy of this range query with a new span
- Type
- RangeQuery
-