[ https://issues.apache.org/jira/browse/SPARK-38509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Max Gekk reassigned SPARK-38509: -------------------------------- Assignee: Max Gekk > Unregister the TIMESTAMPADD/DIFF functions and remove DATE_ADD/DIFF > ------------------------------------------------------------------- > > Key: SPARK-38509 > URL: https://issues.apache.org/jira/browse/SPARK-38509 > Project: Spark > Issue Type: Improvement > Components: SQL > Affects Versions: 3.3.0 > Reporter: Max Gekk > Assignee: Max Gekk > Priority: Major > > 1. Unregister the functions `timestampadd()` and `timestampdiff()` in > `FunctionRegistry.expressions`. > 2. Remove the aliases `date_add` for `timestampadd()` and `date_diff` for > `timestampdiff()`. > 3. Align tests (regenerate golden files) to the syntax rules > where the first parameter `unit` can have one of the identifiers: > - YEAR > - QUARTER > - MONTH > - WEEK > - DAY, DAYOFYEAR (valid for timestampadd) > - HOUR > - MINUTE > - SECOND > - MILLISECOND > - MICROSECOND > h4. Why are the changes needed? > 1. The `timestampadd()`/`timestampdiff()` functions (and their aliases) with > arbitrary string column as the first parameter is not require by any standard. > 2. Remove the functions and aliases should reduce maintenance cost. -- This message was sent by Atlassian Jira (v8.20.1#820001) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org