[SPARK-37520] Add the startswith() and endswith() string functions

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Epic Link: New functions in Spark SQL 3.3
• Assignee: Max Gekk
• Reporter: Max Gekk
• Created: 02/Dec/21 12:20
• Updated: 12/Dec/22 18:10
• Resolved: 03/Dec/21 00:21

Description

startswith() and endswith() are popular in other systems:

Snowflake:

https://docs.snowflake.com/en/sql-reference/functions/startswith.html

https://docs.snowflake.com/en/sql-reference/functions/endswith.html

Cosmos DB:

https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-startswith

https://docs.microsoft.com/en-us/azure/cosmos-db/sql/sql-query-endswith

I would like to propose such functions to Spark SQL to make migration easier.

Issue Links

• relates to: SPARK-37583 Support the binary type by startswith() and endswith()
• links to: [Github] Pull Request #34782 (MaxGekk)