Docs

ByteHouse Cloud Data Warehouse Version

System tables

system.functions

The System table system.functions contains information about regular functions and aggregate functions. You can query this table to view the basic attributes of the functions.

Column names

| | | | \

Field name	Data type	Field description
			\
name	String	Function name.
			\
is_aggregate	UInt8	Whether the function is an aggregate function:	\
			\
		* 1: Indicates the function is an aggregate function.	\
		* 0: Indicates the function is a regular function.
			\
case_insensitive	UInt8	Whether the function is case sensitive.	\
			\
		* 1: Indicates the function is case insensitive; the function name can be in any case.	\
		* 0: Indicates the function is case sensitive; the case must match exactly.
			\
alias_to	String	Function's associated alias. If this field is not null, it means the current function is an alias of another function, such as `total` may be an alias of `sum`.

Example

Filter all aggregate functions

SELECT name 
FROM system.functions 
WHERE is_aggregate = 1 
LIMIT 10;

Example of query results:

Last updated: 2026.03.31 16:19:34

ByteHouse Cloud Data Warehouse Version

Column names #

Example #

Column names

Example