Apache Drill - String Function SUBSTR(x,y,z)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select substr('tutorialspint',4,7) from (values(1));

Result

+----------+
| EXPR$0   |
+----------+
| orialsp  |
+----------+