TS.MGET
TS.MGET [LATEST] [WITHLABELS | SELECTED_LABELS label...] FILTER filterExpr...
- Available in:
- Redis Stack / TimeSeries 1.0.0
- Time complexity:
- O(n) where n is the number of time-series that match the filters
Get the sample with the highest timestamp from each time series matching a specific filter
Required arguments
FILTER filterExpr...
filters time series based on their labels and label values. Each filter expression has one of the following syntaxes:
label=value
, wherelabel
equalsvalue
label!=value
, wherelabel
does not equalvalue
label=
, wherekey
does not have labellabel
label!=
, wherekey
has labellabel
label=(value1,value2,...)
, wherekey
with labellabel
equals one of the values in the listlabel!=(value1,value2,...)
where key with labellabel
does not equal any of the values in the list
- At least one
label=value
filter is required. - Filters are conjunctive. For example, the FILTER
type=temperature room=study
means the a time series is a temperature time series of a study room. - Don't use whitespaces in the filter expression.
Optional arguments
LATEST
(since RedisTimeSeries v1.8)
is used when a time series is a compaction. With LATEST
, TS.MGET also reports the compacted value of the latest possibly partial bucket, given that this bucket's start time falls within [fromTimestamp, toTimestamp]
. Without LATEST
, TS.MGET does not report the latest possibly partial bucket. When a time series is not a compaction, LATEST
is ignored.
The data in the latest bucket of a compaction is possibly partial. A bucket is closed and compacted only upon arrival of a new sample that opens a new latest bucket. There are cases, however, when the compacted value of the latest possibly partial bucket is also required. In such a case, use LATEST
.
WITHLABELS
includes in the reply all label-value pairs representing metadata labels of the time series.
If WITHLABELS
or SELECTED_LABELS
are not specified, by default, an empty list is reported as label-value pairs.
SELECTED_LABELS label...
(since RedisTimeSeries v1.6)
returns a subset of the label-value pairs that represent metadata labels of the time series.
Use when a large number of labels exists per series, but only the values of some of the labels are required.
If WITHLABELS
or SELECTED_LABELS
are not specified, by default, an empty list is reported as label-value pairs.
MGET
command cannot be part of transaction when running on a Redis cluster.
Return value
- Array reply: for each time series matching the specified filters, the following is reported:
- bulk-string-reply: The time series key name
- Array reply: label-value pairs (Bulk string reply, Bulk string reply)
- By default, an empty array is reported
- If
WITHLABELS
is specified, all labels associated with this time series are reported - If
SELECTED_LABELS label...
is specified, the selected labels are reported (null value when no such label defined)
- Array reply: a single timestamp-value pair (Integer reply, Simple string reply (double))
Examples
Select labels to retrieve
Create time series for temperature in Tel Aviv and Jerusalem, then add different temperature samples.
127.0.0.1:6379> TS.CREATE temp:TLV LABELS type temp location TLV
OK
127.0.0.1:6379> TS.CREATE temp:JLM LABELS type temp location JLM
OK
127.0.0.1:6379> TS.MADD temp:TLV 1000 30 temp:TLV 1010 35 temp:TLV 1020 9999 temp:TLV 1030 40
1) (integer) 1000
2) (integer) 1010
3) (integer) 1020
4) (integer) 1030
127.0.0.1:6379> TS.MADD temp:JLM 1005 30 temp:JLM 1015 35 temp:JLM 1025 9999 temp:JLM 1035 40
1) (integer) 1005
2) (integer) 1015
3) (integer) 1025
4) (integer) 1035
Get all the labels associated with the last sample.
127.0.0.1:6379> TS.MGET WITHLABELS FILTER type=temp
1) 1) "temp:JLM"
2) 1) 1) "type"
2) "temp"
2) 1) "location"
2) "JLM"
3) 1) (integer) 1035
2) 40
2) 1) "temp:TLV"
2) 1) 1) "type"
2) "temp"
2) 1) "location"
2) "TLV"
3) 1) (integer) 1030
2) 40
To get only the location
label for each last sample, use SELECTED_LABELS
.
127.0.0.1:6379> TS.MGET SELECTED_LABELS location FILTER type=temp
1) 1) "temp:JLM"
2) 1) 1) "location"
2) "JLM"
3) 1) (integer) 1035
2) 40
2) 1) "temp:TLV"
2) 1) 1) "location"
2) "TLV"
3) 1) (integer) 1030
2) 40
See also
TS.MRANGE
| TS.RANGE
| TS.MREVRANGE
| TS.REVRANGE