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.