Apache Pinot Docs
release-0.10.0
Ask or search…
K

trim

This section contains reference documentation for the trim function.
trim spaces from both side of the string

Signature

TRIM(col)

Usage Examples

SELECT ' Pinot with spaces ' AS notTrimmed,
trim(' Pinot with spaces ') AS trimmed
FROM ignoreMe
notTrimmed
trimmed
" Pinot with spaces "
"Pinot with spaces"