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

any_respect_nulls

Returns the first value encountered in a group, including NULL values (unlike any, which ignores NULLs).

Returns the first value encountered in a group, including NULL values (unlike any, which ignores NULLs).

any

Selects the first encountered value of a column.

anyHeavy

Selects a frequently occurring value using the [heavy hitters](https://doi.