RawTree/docs
BlogDocs
Sign inSign up
Introduction
Get started
AgentsCLIAPI
Concepts
IntroductionResource modelAccess controlIngestion modelRaw tablesDynamic fieldsQueries and resultsStorage and computeAdaptive optimizationSorting keysProjectionsMutationsWorkload schedulingApps, connectors, and transformsSQL workflows
Guides
Overview
Integrations
Reference
Authentication
CLIMCP serverTypeScript SDK
Overview
Data TypesFormatsSystem Tables
FunctionsAIArithmeticArraysBitBitmapComparisonConditionalDates and TimesDictionaryDistanceEmbedded DictionaryEncodingEncryptionFinancialGeoGeo PolygonHashInternalIntrospectionIP AddressJSONLogicalMachine LearningMapMathematicalNatural Language ProcessingNullNumericIndexedVectorOtherQBitRandom NumberRoundingStringString ReplacementString SearchString SplittingTime SeriesTime WindowTupleType ConversionULIDURLUUID
ClickHouse compatibilityLimitsErrors
ReferenceSQL ReferenceFunctions

Functions

Reference for scalar SQL functions by category.

This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See SQL interface scope.

Browse scalar SQL functions grouped by category.

Use the sidebar to navigate to a category.

System Tables

Comments and columns for RawTree system tables.

AI

AI functions reference.

Cookies

  • Necessary, always on: first-party cookies that keep the site working and help us improve it.
  • Third-party analytics: off unless you accept.