Apache Pinot Docs
Search…
latest
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

1
SELECT REPLACE('Hello, World', 'Hello', 'Goodbye') AS value
2
FROM ignoreMe
Copied!
value
Goodbye, World
1
SELECT REPLACE('Hello, World', 'Hellow', 'Goodbye') AS value
2
FROM ignoreMe
Copied!
value
Hello, World
Last modified 1mo ago
Copy link