| approx_top_k_estimate(state, k) |
Returns top k items with their frequency.
`k` An optional INTEGER literal greater than 0. If k is not specified, it defaults to 5. |
| hll_sketch_estimate(expr) |
Returns the estimated number of unique values given the binary representation
of a Datasketches HllSketch. |
| hll_union(first, second, allowDifferentLgConfigK) |
Merges two binary representations of
Datasketches HllSketch objects, using a Datasketches Union object. Set
allowDifferentLgConfigK to true to allow unions of sketches with different
lgConfigK values (defaults to false). |
| kll_sketch_get_n_bigint(expr) |
Returns the number of items collected in the sketch. |
| kll_sketch_get_n_double(expr) |
Returns the number of items collected in the sketch. |
| kll_sketch_get_n_float(expr) |
Returns the number of items collected in the sketch. |
| kll_sketch_get_quantile_bigint(left, right) |
Extracts a single value from the quantiles sketch representing the
desired quantile given the input rank. The desired quantile can either be a single value
or an array. In the latter case, the function will return an array of results of equal
length to the input array. |
| kll_sketch_get_quantile_double(left, right) |
Extracts a single value from the quantiles sketch representing the
desired quantile given the input rank. The desired quantile can either be a single value
or an array. In the latter case, the function will return an array of results of equal
length to the input array. |
| kll_sketch_get_quantile_float(left, right) |
Extracts a single value from the quantiles sketch representing the
desired quantile given the input rank. The desired quantile can either be a single value
or an array. In the latter case, the function will return an array of results of equal
length to the input array. |
| kll_sketch_get_rank_bigint(left, right) |
Extracts a single value from the quantiles sketch representing the
desired rank given the input quantile. The desired rank can either be a single value
or an array. In the latter case, the function will return an array of results of equal
length to the input array. |
| kll_sketch_get_rank_double(left, right) |
Extracts a single value from the quantiles sketch representing the
desired rank given the input quantile. The desired rank can either be a single value
or an array. In the latter case, the function will return an array of results of equal
length to the input array. |
| kll_sketch_get_rank_float(left, right) |
Extracts a single value from the quantiles sketch representing the
desired rank given the input quantile. The desired rank can either be a single value
or an array. In the latter case, the function will return an array of results of equal
length to the input array. |
| kll_sketch_merge_bigint(left, right) |
Merges two sketch buffers together into one. |
| kll_sketch_merge_double(left, right) |
Merges two sketch buffers together into one. |
| kll_sketch_merge_float(left, right) |
Merges two sketch buffers together into one. |
| kll_sketch_to_string_bigint(expr) |
Returns human readable summary information about this sketch. |
| kll_sketch_to_string_double(expr) |
Returns human readable summary information about this sketch. |
| kll_sketch_to_string_float(expr) |
Returns human readable summary information about this sketch. |
| theta_difference(first, second) |
Subtracts two binary representations of
Datasketches ThetaSketch objects from two input columns using a
ThetaSketch AnotB object. |
| theta_intersection(first, second) |
Intersects two binary representations of
Datasketches ThetaSketch objects from two input columns using a
ThetaSketch Intersect object. |
| theta_sketch_estimate(expr) |
Returns the estimated number of unique values
given the binary representation of a Datasketches ThetaSketch. |
| theta_union(first, second, lgNomEntries) |
Merges two binary representations of
Datasketches ThetaSketch objects using a ThetaSketch Union object. Users can set
lgNomEntries to a value between 4 and 26 to find the union of sketches with different
union buffer size values (defaults to 12). |
| tuple_difference_double(tupleSketch1, tupleSketch2) |
Subtracts two binary representations of Datasketches
TupleSketch objects with double summary data type using a TupleSketch AnotB object.
Returns elements in the first sketch that are not in the second sketch. |
| tuple_difference_integer(tupleSketch1, tupleSketch2) |
Subtracts two binary representations of Datasketches
TupleSketch objects with integer summary data type using a TupleSketch AnotB object.
Returns elements in the first sketch that are not in the second sketch. |
| tuple_intersection_double(tupleSketch1, tupleSketch2, mode) |
Intersects two binary representations of Datasketches
TupleSketch objects with double summary data type using a TupleSketch Intersection object.
Users can set mode to 'sum', 'min', 'max', or 'alwaysone' (defaults to 'sum'). |
| tuple_intersection_integer(tupleSketch1, tupleSketch2, mode) |
Intersects two binary representations of Datasketches
TupleSketch objects with integer summary data type using a TupleSketch Intersection object.
Users can set mode to 'sum', 'min', 'max', or 'alwaysone' (defaults to 'sum'). |
| tuple_sketch_estimate_double(child) |
Returns the estimated number of unique values
given the binary representation of a Datasketches TupleSketch. The sketch's
summary type must be a double. |
| tuple_sketch_estimate_integer(child) |
Returns the estimated number of unique values
given the binary representation of a Datasketches TupleSketch. The sketch's
summary type must be an integer. |
| tuple_sketch_summary_double(child, mode) |
Aggregates the summary values from a double summary type
Datasketches TupleSketch. The mode can be 'sum', 'min', 'max', or 'alwaysone'
(defaults to 'sum'). |
| tuple_sketch_summary_integer(child, mode) |
Aggregates the summary values from a integer summary type
Datasketches TupleSketch. The mode can be 'sum', 'min', 'max', or 'alwaysone'
(defaults to 'sum'). |
| tuple_sketch_theta_double(child) |
Returns the theta value (sampling rate) from a Datasketches TupleSketch.
The theta value represents the effective sampling rate of the sketch, between 0.0 and 1.0.
The sketch's summary type must be a double. |
| tuple_sketch_theta_integer(child) |
Returns the theta value (sampling rate) from a Datasketches TupleSketch.
The theta value represents the effective sampling rate of the sketch, between 0.0 and 1.0.
The sketch's summary type must be an integer. |
| tuple_union_double(tupleSketch1, tupleSketch2, lgNomEntries, mode) |
Merges two binary representations of Datasketches
TupleSketch objects with double summary data type using a TupleSketch Union object. Users can
set lgNomEntries to a value between 4 and 26 (defaults to 12) and mode to 'sum', 'min', 'max',
or 'alwaysone' (defaults to 'sum'). |
| tuple_union_integer(tupleSketch1, tupleSketch2, lgNomEntries, mode) |
Merges two binary representations of Datasketches
TupleSketch objects with integer summary data type using a TupleSketch Union object. Users can
set lgNomEntries to a value between 4 and 26 (defaults to 12) and mode to 'sum', 'min', 'max',
or 'alwaysone' (defaults to 'sum'). |