startswith

This section contains reference documentation for the STARTSWITH function.

returns true if columns starts with prefix string.

Signature

STARTSWITH(col, prefix)

Usage Examples

SELECT STARTSWITH('Apache Pinot', 'Apache') AS value
FROM ignoreMe

value
true

SELECT STARTSWITH('Apache Pinot', 'Pinot') AS value
FROM ignoreMe

value
false