ReferenceSQL ReferenceFunctions

Internal

Internal functions reference.

_CAST

This function is used internally by RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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 RawTree (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.