TimeBoundary queries

info

Apache Druid supports two query languages: Druid SQL and native queries. This document describes a query type that is only available in the native language.

Time boundary queries return the earliest and latest data points of a data set. The grammar is:

{
    "queryType" : "timeBoundary",
    "dataSource": "sample_datasource",
    "bound"     : < "maxTime" | "minTime" > # optional, defaults to returning both timestamps if not set
    "filter"    : { "type": "and", "fields": [<filter>, <filter>, ...] } # optional
}

There are 3 main parts to a time boundary query:

property	description	required?
queryType	This String should always be "timeBoundary"; this is the first thing Apache Druid looks at to figure out how to interpret the query	yes
dataSource	A String or Object defining the data source to query, very similar to a table in a relational database. See DataSource for more information.	yes
bound	Optional, set to maxTime or minTime to return only the latest or earliest timestamp. Default to returning both if not set	no
filter	See Filters	no
context	See Context	no

The format of the result is:

[ {
  "timestamp" : "2013-05-09T18:24:00.000Z",
  "result" : {
    "minTime" : "2013-05-09T18:24:00.000Z",
    "maxTime" : "2013-05-09T18:37:00.000Z"
  }
} ]