Apache Drill - String Function LOWER(x)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select lower('APACHE DRILL') from (values(1));

Result

+--+
|   EXPR$0     |
+--+
| apache drill |
+--+

It converts the given string to a lower case format.