Apache Pinot Docs
Search…
latest
trim
This section contains reference documentation for the trim function.
trim spaces from both side of the string

Signature

TRIM(col)

Usage Examples

1
SELECT ' Pinot with spaces ' AS notTrimmed,
2
trim(' Pinot with spaces ') AS trimmed
3
FROM ignoreMe
Copied!
notTrimmed
trimmed
" Pinot with spaces "
"Pinot with spaces"
Last modified 1mo ago
Copy link