groupBy query

Usage

druid.query.groupBy(url = druid.url(), dataSource, intervals, aggregations, filter = NULL, 
  granularity = "all", dimensions = NULL, postAggregations = NULL, having = NULL, 
      orderBy = NULL, limit = NULL, context = NULL, rawData = FALSE, verbose = F, ...)

Arguments

url

URL to connect to druid, defaults to druid.url()

dataSource

name of the data source to query

intervals

the time period to retrieve data for as an interval or list of interval objects

aggregations

list of metric aggregations to compute for this datasource See druid.build.aggregation

filter

The filter specifying the subset of the data to extract. See druid.build.filter

having

The having clause identifying which rows should be returned. See druid.build.having

granularity

time granularity at which to aggregate, can be "all", "day", "hour", "minute"

dimensions

list of dimensions along which to group data by

postAggregations

Further operations to perform after the data has been filtered and aggregated.

orderBy

list of columns defining the output order

limit

number of results to limit output based on the ordering defined in orderBy

context

query context

rawData

boolean indicating whether or not to return the JSON in a list before converting to a data frame

verbose

prints out the JSON query sent to druid

See also

druid.query.timeseries druid.query.topN