Apache Pinot Docs
Search…
latest
Configuration Reference
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 6mo ago
Copy link