Apache Drill - String Function CONCAT(x,y)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select concat('apache','drill') from (values(1));

Result

+-+
|    EXPR$0    |
+-+
| apachedrill  |
+-+

The above query produces the result of concatenation of two specified strings.