RawTree/docs
Sign in
Introduction
Quickstart
AgentsCLIAPI
Guides
Ingest dataQuery dataTransformsSQL workflowsOpenTelemetryPrometheusSplunkDataHub
Reference
APIWorkflows APICLIMCP serverAuthenticationTypeScript SDK
OverviewData TypesSELECT
Aggregate FunctionsaggThrowanalysisOfVarianceanyany_respect_nullsanyHeavyanyLastanyLast_respect_nullsapprox_top_kapprox_top_sumargAndMaxargAndMinargMaxargMinavgavgWeightedboundingRatiocategoricalInformationValuecontingencycorrcorrMatrixcorrStablecountcovarPopcovarPopMatrixcovarPopStablecovarSampcovarSampMatrixcovarSampStablecramersVcramersVBiasCorrectedcume_distdeltaSumdeltaSumTimestampdenseRankdistinctDynamicTypesdistinctJSONPathsdistinctJSONPathsAndTypesentropyestimateCompressionRatioexponentialMovingAverageexponentialTimeDecayedAvgexponentialTimeDecayedCountexponentialTimeDecayedMaxexponentialTimeDecayedSumflameGraphgroupArraygroupArrayInsertAtgroupArrayIntersectgroupArrayLastgroupArrayMovingAvggroupArrayMovingSumgroupArraySamplegroupArraySortedgroupBitAndgroupBitmapgroupBitmapAndgroupBitmapOrgroupBitmapXorgroupBitOrgroupBitXorgroupConcatgroupFormatgroupNumericIndexedVectorgroupUniqArrayhistogramintervalLengthSumkolmogorovSmirnovTestkurtPopkurtSamplaglagInFramelargestTriangleThreeBucketsleadleadInFramemannWhitneyUTestmaxmaxIntersectionsmaxIntersectionsPositionmaxMappedArraysmeanZTestminminMappedArraysMVTEncodenonNegativeDerivativenothingnothingNullnothingUInt64nth_valuentilepercentRankquantilequantileBFloat16quantileBFloat16WeightedquantileDDquantileDeterministicquantileExactquantileExactExclusivequantileExactHighquantileExactInclusivequantileExactLowquantileExactWeightedquantileExactWeightedInterpolatedquantileGKquantileInterpolatedWeightedquantilePrometheusHistogramquantilesquantilesBFloat16quantilesBFloat16WeightedquantilesDDquantilesDeterministicquantilesExactquantilesExactExclusivequantilesExactHighquantilesExactInclusivequantilesExactLowquantilesExactWeightedquantilesExactWeightedInterpolatedquantilesGKquantilesInterpolatedWeightedquantilesPrometheusHistogramquantilesTDigestquantilesTDigestWeightedquantilesTimingquantilesTimingWeightedquantileTDigestquantileTDigestWeightedquantileTimingquantileTimingWeightedrankrankCorrretentionrow_numbersequenceCountsequenceMatchsequenceMatchEventssequenceNextNodesimpleLinearRegressionsingleValueOrNullskewPopskewSampsparkbarstddevPopstddevPopStablestddevSampstddevSampStablestochasticLinearRegressionstochasticLogisticRegressionstudentTTeststudentTTestOneSamplesumsumCountsumKahansumMapFilteredsumMapFilteredWithOverflowsumMappedArrayssumMapWithOverflowsumWithOverflowtheilsUtimeSeriesChangesToGridtimeSeriesDeltaToGridtimeSeriesDerivToGridtimeSeriesGroupArraytimeSeriesIncreaseToGridtimeSeriesInstantDeltaToGridtimeSeriesInstantRateToGridtimeSeriesLastTwoSamplestimeSeriesPredictLinearToGridtimeSeriesRateToGridtimeSeriesResampleToGridWithStalenesstimeSeriesResetsToGridtopKtopKWeighteduniquniqCombineduniqCombined64uniqExactuniqHLL12uniqThetauniqUpTovarPopvarPopStablevarSampvarSampStablewelchTTestwindowFunnel
ReferenceSQL ReferenceAggregate Functions

Aggregate Functions

Reference for aggregate SQL functions.

Browse aggregate SQL functions.

Use the sidebar to navigate to a function.

UUID

UUID functions reference.

aggThrow

This function can be used for the purpose of testing exception safety.