SQL CONTAINS Function is not working on Databricks

Prasann_gupta
New Contributor

I am trying to use sql CONTAINS function in my sql query but it is throwing the below error :

AnalysisException: Undefined function: 'CONTAINS'. This function is neither a registered temporary function nor a permanent function registered in the database 'default'.; line 14 pos