SPACE function in Cloudera's Impala

There are some of the functions that hardly come into use. Often this kind of function would have some other replacement that we use. SPACE is one of the functions introduced by Cloudera's Impala, which returns the concatenated string to the specified number of spaces.

Let's see what it does.

SELECT SPACE(10);

Result:

SPACE(10)

---------------

'       '

SELECT CONCAT('firstname', space(1), 'lastname');

Result:

contact('firstname', space(1), 'lastname')

------------------------------------------------

firstname lastname