<table class="table">
  <thead>
    <tr>
      <th style="width:25%">Function</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>approx_top_k_estimate(state, k)</td>
      <td>Returns top k items with their frequency.
      `k` An optional INTEGER literal greater than 0. If k is not specified, it defaults to 5.</td>
    </tr>
    <tr>
      <td>hll_sketch_estimate(expr)</td>
      <td>Returns the estimated number of unique values given the binary representation
    of a Datasketches HllSketch.</td>
    </tr>
    <tr>
      <td>hll_union(first, second, allowDifferentLgConfigK)</td>
      <td>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).</td>
    </tr>
    <tr>
      <td>kll_sketch_get_n_bigint(expr)</td>
      <td>Returns the number of items collected in the sketch.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_n_double(expr)</td>
      <td>Returns the number of items collected in the sketch.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_n_float(expr)</td>
      <td>Returns the number of items collected in the sketch.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_quantile_bigint(left, right)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_quantile_double(left, right)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_quantile_float(left, right)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_rank_bigint(left, right)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_rank_double(left, right)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>kll_sketch_get_rank_float(left, right)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>kll_sketch_merge_bigint(left, right)</td>
      <td>Merges two sketch buffers together into one.</td>
    </tr>
    <tr>
      <td>kll_sketch_merge_double(left, right)</td>
      <td>Merges two sketch buffers together into one.</td>
    </tr>
    <tr>
      <td>kll_sketch_merge_float(left, right)</td>
      <td>Merges two sketch buffers together into one.</td>
    </tr>
    <tr>
      <td>kll_sketch_to_string_bigint(expr)</td>
      <td>Returns human readable summary information about this sketch.</td>
    </tr>
    <tr>
      <td>kll_sketch_to_string_double(expr)</td>
      <td>Returns human readable summary information about this sketch.</td>
    </tr>
    <tr>
      <td>kll_sketch_to_string_float(expr)</td>
      <td>Returns human readable summary information about this sketch.</td>
    </tr>
    <tr>
      <td>theta_difference(first, second)</td>
      <td>Subtracts two binary representations of
    Datasketches ThetaSketch objects from two input columns using a
    ThetaSketch AnotB object.</td>
    </tr>
    <tr>
      <td>theta_intersection(first, second)</td>
      <td>Intersects two binary representations of
    Datasketches ThetaSketch objects from two input columns using a
    ThetaSketch Intersect object.</td>
    </tr>
    <tr>
      <td>theta_sketch_estimate(expr)</td>
      <td>Returns the estimated number of unique values
    given the binary representation of a Datasketches ThetaSketch.</td>
    </tr>
    <tr>
      <td>theta_union(first, second, lgNomEntries)</td>
      <td>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).</td>
    </tr>
    <tr>
      <td>tuple_difference_double(tupleSketch1, tupleSketch2)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>tuple_difference_integer(tupleSketch1, tupleSketch2)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>tuple_difference_theta_double(tupleSketch, thetaSketch)</td>
      <td>Subtracts the binary representation of a
    Datasketches ThetaSketch from a TupleSketch with double summary data type using a TupleSketch
    AnotB object. Returns elements in the TupleSketch that are not in the ThetaSketch.</td>
    </tr>
    <tr>
      <td>tuple_difference_theta_integer(tupleSketch, thetaSketch)</td>
      <td>Subtracts the binary representation of a
    Datasketches ThetaSketch from a TupleSketch with integer summary data type using a TupleSketch
    AnotB object. Returns elements in the TupleSketch that are not in the ThetaSketch.</td>
    </tr>
    <tr>
      <td>tuple_intersection_double(tupleSketch1, tupleSketch2, mode)</td>
      <td>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').</td>
    </tr>
    <tr>
      <td>tuple_intersection_integer(tupleSketch1, tupleSketch2, mode)</td>
      <td>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').</td>
    </tr>
    <tr>
      <td>tuple_intersection_theta_double(tupleSketch, thetaSketch, mode)</td>
      <td>Intersects the binary representation of a
    Datasketches TupleSketch with double summary data type with the binary representation of a
    Datasketches ThetaSketch using a TupleSketch Intersection object. The ThetaSketch entries are
    assigned a default double summary value based on the mode: 0.0 for 'sum' mode, +Infinity for
    'min' mode, -Infinity for 'max' mode, or 1.0 for 'alwaysone' mode. Users can set mode to 'sum',
    'min', 'max', or 'alwaysone' (defaults to 'sum').</td>
    </tr>
    <tr>
      <td>tuple_intersection_theta_integer(tupleSketch, thetaSketch, mode)</td>
      <td>Intersects the binary representation of a
    Datasketches TupleSketch with integer summary data type with the binary representation of a
    Datasketches ThetaSketch using a TupleSketch Intersection object. The ThetaSketch entries are
    assigned a default integer summary value based on the mode: 0 for 'sum' mode, Integer.MAX_VALUE
    for 'min' mode, Integer.MIN_VALUE for 'max' mode, or 1 for 'alwaysone' mode. Users can set mode
    to 'sum', 'min', 'max', or 'alwaysone' (defaults to 'sum').</td>
    </tr>
    <tr>
      <td>tuple_sketch_estimate_double(child)</td>
      <td>Returns the estimated number of unique values
    given the binary representation of a Datasketches TupleSketch. The sketch's
    summary type must be a double.</td>
    </tr>
    <tr>
      <td>tuple_sketch_estimate_integer(child)</td>
      <td>Returns the estimated number of unique values
    given the binary representation of a Datasketches TupleSketch. The sketch's
    summary type must be an integer.</td>
    </tr>
    <tr>
      <td>tuple_sketch_summary_double(child, mode)</td>
      <td>Aggregates the summary values from a double summary type
    Datasketches TupleSketch. The mode can be 'sum', 'min', 'max', or 'alwaysone'
    (defaults to 'sum').</td>
    </tr>
    <tr>
      <td>tuple_sketch_summary_integer(child, mode)</td>
      <td>Aggregates the summary values from a integer summary type
    Datasketches TupleSketch. The mode can be 'sum', 'min', 'max', or 'alwaysone'
    (defaults to 'sum').</td>
    </tr>
    <tr>
      <td>tuple_sketch_theta_double(child)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>tuple_sketch_theta_integer(child)</td>
      <td>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.</td>
    </tr>
    <tr>
      <td>tuple_union_double(tupleSketch1, tupleSketch2, lgNomEntries, mode)</td>
      <td>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').</td>
    </tr>
    <tr>
      <td>tuple_union_integer(tupleSketch1, tupleSketch2, lgNomEntries, mode)</td>
      <td>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').</td>
    </tr>
    <tr>
      <td>tuple_union_theta_double(tupleSketch, thetaSketch, lgNomEntries, mode)</td>
      <td>Merges the binary representation of a
    Datasketches TupleSketch with double summary data type with the binary representation of a
    Datasketches ThetaSketch using a TupleSketch Union object. The ThetaSketch entries are assigned
    a default double summary value based on the mode: 0.0 for 'sum' mode, +Infinity for 'min' mode,
    -Infinity for 'max' mode, or 1.0 for 'alwaysone' mode. 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').</td>
    </tr>
    <tr>
      <td>tuple_union_theta_integer(tupleSketch, thetaSketch, lgNomEntries, mode)</td>
      <td>Merges the binary representation of a
    Datasketches TupleSketch with integer summary data type with the binary representation of a
    Datasketches ThetaSketch using a TupleSketch Union object. The ThetaSketch entries are assigned
    a default integer summary value based on the mode: 0 for 'sum' mode, Integer.MAX_VALUE for 'min'
    mode, Integer.MIN_VALUE for 'max' mode, or 1 for 'alwaysone' mode. 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').</td>
    </tr>
  </tbody>
</table>
Function	Description
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_difference_theta_double(tupleSketch, thetaSketch)	Subtracts the binary representation of a Datasketches ThetaSketch from a TupleSketch with double summary data type using a TupleSketch AnotB object. Returns elements in the TupleSketch that are not in the ThetaSketch.
tuple_difference_theta_integer(tupleSketch, thetaSketch)	Subtracts the binary representation of a Datasketches ThetaSketch from a TupleSketch with integer summary data type using a TupleSketch AnotB object. Returns elements in the TupleSketch that are not in the ThetaSketch.
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_intersection_theta_double(tupleSketch, thetaSketch, mode)	Intersects the binary representation of a Datasketches TupleSketch with double summary data type with the binary representation of a Datasketches ThetaSketch using a TupleSketch Intersection object. The ThetaSketch entries are assigned a default double summary value based on the mode: 0.0 for 'sum' mode, +Infinity for 'min' mode, -Infinity for 'max' mode, or 1.0 for 'alwaysone' mode. Users can set mode to 'sum', 'min', 'max', or 'alwaysone' (defaults to 'sum').
tuple_intersection_theta_integer(tupleSketch, thetaSketch, mode)	Intersects the binary representation of a Datasketches TupleSketch with integer summary data type with the binary representation of a Datasketches ThetaSketch using a TupleSketch Intersection object. The ThetaSketch entries are assigned a default integer summary value based on the mode: 0 for 'sum' mode, Integer.MAX_VALUE for 'min' mode, Integer.MIN_VALUE for 'max' mode, or 1 for 'alwaysone' mode. 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').
tuple_union_theta_double(tupleSketch, thetaSketch, lgNomEntries, mode)	Merges the binary representation of a Datasketches TupleSketch with double summary data type with the binary representation of a Datasketches ThetaSketch using a TupleSketch Union object. The ThetaSketch entries are assigned a default double summary value based on the mode: 0.0 for 'sum' mode, +Infinity for 'min' mode, -Infinity for 'max' mode, or 1.0 for 'alwaysone' mode. 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_theta_integer(tupleSketch, thetaSketch, lgNomEntries, mode)	Merges the binary representation of a Datasketches TupleSketch with integer summary data type with the binary representation of a Datasketches ThetaSketch using a TupleSketch Union object. The ThetaSketch entries are assigned a default integer summary value based on the mode: 0 for 'sum' mode, Integer.MAX_VALUE for 'min' mode, Integer.MIN_VALUE for 'max' mode, or 1 for 'alwaysone' mode. 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').