Apache Presto - lpad(string,size,padstring)


Query

presto:default> select lpad(‘Presto',5,'o') as string_padding; 

Result

 string_padding 
---------------- 
     Prest 

The output is the left padding of the string size.

apache_presto_sql_functions.htm
Advertisements