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

anyLast_respect_nulls

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

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

anyLast

Selects the last encountered value of a column.

approx_top_k

Returns an array of the approximately most frequent values and their counts in the specified column.