Apache Drill - String Function RTRIM(x)



The following program shows the query for this function −

Query

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

Result

+——————————-+
|   EXPR$0  |
+——————————-+
| tutorials |
+———————————+

Right trimming the characters form the two given strings.

apache_drill_sql_operations.htm
Advertisements