ReferenceSQL ReferenceFunctions

Internal

Internal functions reference.

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.

_CAST

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__actionName

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__applyFilter

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__bitBoolMaskAnd

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__bitBoolMaskOr

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__bitSwapLastTwo

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__bitWrapperFunc

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__getScalar

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__groupingForCube

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__groupingForGroupingSets

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__groupingForRollup

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__groupingOrdinary

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__patchPartitionID

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__scalarSubqueryResult

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

__toYearCalendarOnly

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

caseWithExpression

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.

nested

This is a function used internally by RawTree and not meant to be used directly.

Returns the array of tuples from multiple arrays.

The first argument must be a constant array of Strings determining the names of the resulting Tuple. The other arguments must be arrays of the same size.

Examples

nested

SELECT nested(['keys', 'values'], ['key_1', 'key_2'], ['value_1','value_2'])

Introduced in version 23.2.0.

validateNestedArraySizes

This function is used internally by ClickHouse (for example by the query planner or by other functions) and is not part of the public interface. It should not be used directly and may change or be removed at any time.