Apache Pinot Docs
latest
Search…
⌃K

replace

This section contains reference documentation for the REPLACE function.
replace all instances of find with replace in input

Signature

REPLACE(col, find, replace)

Usage Examples

SELECT REPLACE('Hello, World', 'Hello', 'Goodbye') AS value
FROM ignoreMe
value
Goodbye, World
SELECT REPLACE('Hello, World', 'Hellow', 'Goodbye') AS value
FROM ignoreMe
value
Hello, World
Last modified 1yr ago