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
