Apache Tajo - left(string text, int size)

Let us now check the left(string,size) function with the following query.

Query

default> select left('tutorialspoint',2) as leftshift;

Result

The above query will generate the following result.

leftshift 
------------------------------- 
tu

The query returns left padding for the string with the given size.