Compute quantiles over non-NULL values (without interpolation, needs a database with window functions).

Please see https://github.com/WinVector/rquery/blob/master/extras/Summary_Example.md for an example.

quantile_node(
  source,
  cols = NULL,
  ...,
  probs_name = "quantile_probability",
  probs = seq(0, 1, 0.25),
  tmp_name_source = wrapr::mk_tmp_name_source("qn"),
  temporary = TRUE,
  qualifiers = NULL
)

Arguments

source	source to select from (relop or data.frame).
cols	character, compute quantiles for these columns (NULL indicates all columns).
...	force later arguments to be bound by name
probs_name	character, column name to write probs in.
probs	numeric quantiles to compute
tmp_name_source	wrapr::mk_tmp_name_source(), temporary name generator.
temporary	logical, if TRUE use temporary tables
qualifiers	optional named ordered vector of strings carrying additional db hierarchy terms, such as schema.

Value

table of quantiles

Details

This is a non_sql_node, so please see non_sql_node for some of the issues for this node type.

See also

quantile_cols, rsummary, non_sql_node