Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Built-in Functions/ String Functions/ space
Updated on 2023-10-25 GMT+08:00
View PDF
Share

space

This function is used to return a specified number of spaces.

Syntax

space(bigint <n>)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

n

Yes

BIGINT

Number of spaces

Return Values

The return value is of the STRING type.

  • If the value of n is empty, an error is reported.
  • If the value of n is NULL, NULL is returned.

Example Code

The value 6 is returned.

select length(space(6));
Parent topic: String Functions