Showing posts with label space(). Show all posts
Showing posts with label space(). Show all posts

Friday, October 2, 2020

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



Big Data & SQL

Hi Everybody, Please do visit my new blog that has much more information about Big Data and SQL. The site covers big data and almost all the...