layout: doc_page

Time Boundary Queries

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 
}

There are 3 main parts to a time boundary query:

propertydescriptionrequired?
queryTypeThis String should always be “timeBoundary”; this is the first thing Druid looks at to figure out how to interpret the queryyes
dataSourceA String defining the data source to query, very similar to a table in a relational databaseyes
boundOptional, set to maxTime or minTime to return only the latest or earliest timestamp. Default to returning both if not setno
contextAn additional JSON Object which can be used to specify certain flags.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"
  }
} ]