Apache Pinot Docs
Search…
latest
Configuration Reference
strpos
This section contains reference documentation for the STRPOS function.
Find Nth instance of find string in input. Returns 0 if input string is empty. Returns -1 if the Nth instance is not found or input string is null.

Signature

STRPOS(col, find, N)

Usage Examples

1
SELECT STRPOS('Apache Pinot is a column-oriented, open-source, distributed data store written in Java', 'o', 1) AS value
2
FROM ignoreMe
Copied!
value
10
1
SELECT STRPOS('Apache Pinot is a column-oriented, open-source, distributed data store written in Java', 'o', 2) AS value
2
FROM ignoreMe
Copied!
value
19
1
SELECT STRPOS('Apache Pinot is a column-oriented, open-source, distributed data store written in Java', 'z', 1) AS value
2
FROM ignoreMe
Copied!
value
-1
Last modified 6mo ago
Copy link