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_distdeltaSumdeltaSumTimestampdenseRankdistinctDynamicTypesdistinctJSONPathsdistinctJSONPathsAndTypesentropyestimateCompressionRatioexponentialMovingAverageexponentialTimeDecayedAvgexponentialTimeDecayedCountexponentialTimeDecayedMaxexponentialTimeDecayedSumflameGraphginigroupArraygroupArrayInsertAtgroupArrayIntersectgroupArrayLastgroupArrayMovingAvggroupArrayMovingSumgroupArraySamplegroupArraySortedgroupBitAndgroupBitmapgroupBitmapAndgroupBitmapOrgroupBitmapXorgroupBitOrgroupBitXorgroupConcatgroupFormatgroupNumericIndexedVectorgroupUniqArrayhistogramintervalLengthSumkolmogorovSmirnovTestkurtPopkurtSamplaglagInFramelargestTriangleThreeBucketsleadleadInFramemannWhitneyUTestmaxmaxIntersectionsmaxIntersectionsPositionmaxMappedArraysmeanZTestmergedJSONPatchminminMappedArraysMVTEncodenonNegativeDerivativenothingnothingNullnothingUInt64nth_valuentilepercentRankquantilequantileBFloat16quantileBFloat16WeightedquantileDDquantileDeterministicquantileExactquantileExactExclusivequantileExactHighquantileExactInclusivequantileExactLowquantileExactWeightedquantileExactWeightedInterpolatedquantileGKquantileInterpolatedWeightedquantilePrometheusHistogramquantilesquantilesBFloat16quantilesBFloat16WeightedquantilesDDquantilesDeterministicquantilesExactquantilesExactExclusivequantilesExactHighquantilesExactInclusivequantilesExactLowquantilesExactWeightedquantilesExactWeightedInterpolatedquantilesGKquantilesInterpolatedWeightedquantilesPrometheusHistogramquantilesTDigestquantilesTDigestWeightedquantilesTimingquantilesTimingWeightedquantileTDigestquantileTDigestWeightedquantileTimingquantileTimingWeightedrankrankCorrretentionrow_numbersequenceCountsequenceMatchsequenceMatchEventssequenceNextNodesimpleLinearRegressionsingleValueOrNullskewPopskewSampsparkbarstddevPopstddevPopStablestddevSampstddevSampStablestochasticLinearRegressionstochasticLogisticRegressionstudentTTeststudentTTestOneSamplesumsumCountsumKahansumMapFilteredsumMapFilteredWithOverflowsumMappedArrayssumMapWithOverflowsumWithOverflowtheilsUtimeSeriesBottomKMaskstimeSeriesChangesToGridtimeSeriesDeltaToGridtimeSeriesDerivToGridtimeSeriesGroupArraytimeSeriesIncreaseToGridtimeSeriesInstantDeltaToGridtimeSeriesInstantRateToGridtimeSeriesLastTwoSamplestimeSeriesLimitKMaskstimeSeriesPredictLinearToGridtimeSeriesRateToGridtimeSeriesResampleToGridWithStalenesstimeSeriesResetsToGridtimeSeriesTopKMaskstopKtopKWeighteduniquniqCombineduniqCombined64uniqExactuniqHLL12uniqThetauniqUpTovarPopvarPopStablevarSampvarSampStablewelchTTestwindowFunnel
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.