Apache Drill - String Function STRPOS(x,y)

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select strpos('tutorialpoint','o') from (values(1));

Result

+————————+
| EXPR$0 |
+————————+
|   4    |
+————————+

The output indicates the position of ‘o’ occurs first in the given string.

Kickstart Your Career

Get certified by completing the course

Get Started