Apache Drill - String Function LTRIM(x)



The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select ltrim('tutorialspoint','point') from (values(1));

Result

+——————————————-+
|     EXPR$0    |
+——————————————-+
| utorialspoint |
+———————————————+

Left trimming the character from the given string.

apache_drill_sql_operations.htm
Advertisements