druid.query.groupBy: groupBy query

Description Usage Arguments Value See Also

Description

Sends a groupBy query to Druid and returns the results as a data frame

Usage

1
2
3
4
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

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.

having

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

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

Value

Returns a dataframe where each column represents a time series

See Also

druid.query.timeseries druid.query.topN


druid-io/RDruid documentation built on May 15, 2019, 2:54 p.m.