Window Functions Overview DENSE_RANK() RANK() ROW_NUMBER()

Operators Functions

AVG COUNT MAX MIN SUM ANY_VALUE BIT_AND BIT_OR BIT_XOR STDDEV_POP VAR

LAST_QUERY_ID() LAST_INSERT_ID()

Mathematical Datetime String

All Druid SQL functions ABS ACOS ANY_VALUE APPROX_COUNT_DISTINCT APPROX_COUNT_DISTINCT_DS_HLL APPROX_COUNT_DISTINCT_DS_THETA APPROX_QUANTILE APPROX_QUANTILE_DS APPROX_QUANT...

SQL JSON functions JSONPath syntax SQL JSON functions Druid supports nested columns, which provide optimized storage and indexes for nested data structures. See Nested columns ...

SQL scalar functions Numeric functions String functions Date and time functions Reduction functions IP address functions Sketch functions HLL sketch functions Theta sketch fu...

Aggregate functions GROUP BY Using an identifier in GROUP BY Using an ordinal in GROUP BY Using an expression in GROUP BY SELECT Using aggregate expressions directly in SELECT ...

DataFusion Functions Scalar Functions Math Functions abs Arguments acos Arguments acosh Arguments asin Arguments asinh Arguments atan Arguments atanh Arguments ...