Apache Pinot Docs
latest
Search…
⌃K

ltrim

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

Signature

LTRIM(col)

Usage Examples

SELECT ' Pinot with spaces ' AS notTrimmed,
ltrim(' Pinot with spaces ') AS trimmed
FROM ignoreMe
notTrimmed
trimmed
" Pinot with spaces "
"Pinot with spaces "
Last modified 1yr ago