# Internal (/docs/reference/sql/functions/internal)



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](/docs/reference/clickhouse-compatibility#service-interfaces).

\_CAST [#_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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#__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 [#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 [#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**

```sql title=Query
SELECT nested(['keys', 'values'], ['key_1', 'key_2'], ['value_1','value_2'])
```

*Introduced in version 23.2.0.*

validateNestedArraySizes [#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.
