Apache Pinot Docs
latest
Search…
⌃K

substr

This section contains reference documentation for the substr function.
Get substring of the input string from start to endIndex. Index begins at 0. Set endIndex to -1 to calculate till end of the string

Signature

SUBSTR(col, startIndex, endIndex)

Usage Examples

select SUBSTR('Pinot', 1, -1) AS name
FROM ignoreMe
name
inot
select SUBSTR('Pinot', 0, 2) AS name
FROM ignoreMe
name
Pi
Last modified 1yr ago