Apache Presto - String Operator


String operator “||” performs concatenation.

Query

presto:default> select 'tutorials' || 'point' as string_concat;

Result

 string_concat 
---------------- 
 tutorialspoint

Here, the output is performed as a concatenation of the two given strings.

apache_presto_basic_sql_operations.htm
Advertisements