[SPARK-30606] Applying the `like` function with 2 parameters fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.0.0
• Component/s: SQL
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 22/Jan/20 19:14
• Updated: 22/Jan/20 23:40
• Resolved: 22/Jan/20 23:40

Description

The `Like` expression is registered as the `like` function. Applying the function with 2 parameters fails with the exception:

spark-sql> select like('Spark', 'S%');

Invalid arguments for function like; line 1 pos 7
org.apache.spark.sql.AnalysisException: Invalid arguments for function like; line 1 pos 7
	at org.apache.spark.sql.catalyst.analysis.FunctionRegistry$.$anonfun$expression$7(FunctionRegistry.scala:618)
	at scala.Option.getOrElse(Option.scala:189)
	at org.apache.spark.sql.catalyst.analysis.FunctionRegistry$.$anonfun$expression$4(FunctionRegistry.scala:602)
	at org.apache.spark.sql.catalyst.analysis.SimpleFunctionRegistry.lookupFunction(FunctionRegistry.scala:121)
	at org.apache.spark.sql.catalyst.catalog.SessionCatalog.lookupFunction(SessionCatalog.scala:1412)

Issue Links

• is caused by: SPARK-28083 Support ANSI SQL: LIKE ... ESCAPE syntax
• links to: GitHub Pull Request #27323