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.