flink icon indicating copy to clipboard operation
flink copied to clipboard

[FLINK-26945][table] Add built-in DATE_SUB function.

Open liuyongvs opened this issue 2 years ago • 3 comments

  • What is the purpose of the change This is an implementation of DATE_SUB

  • Brief change log DATE_SUB for Table API and SQL

    Syntax:
     date_sub(startDate, days) 
    
    > SELECT date_sub(DATE '2019-01-01', 1);
    2018-12-31
    

    See also Spark Hive

  • Does this pull request potentially affect one of the following parts: Dependencies (does it add or upgrade a dependency): ( no) The public API, i.e., is any changed class annotated with @Public(Evolving): (yes ) The serializers: (no) The runtime per-record code paths (performance sensitive): ( no) Anything that affects deployment or recovery: JobManager (and its components), Checkpointing, Kubernetes/Yarn, ZooKeeper: ( no) The S3 file system connector: ( no)

  • Documentation Does this pull request introduce a new feature? (yes) If yes, how is the feature documented? (docs)

liuyongvs avatar Mar 23 '23 10:03 liuyongvs

CI report:

  • a554381cd3cfd6999950ee5b2a5fe470338762f0 Azure: SUCCESS
Bot commands The @flinkbot bot supports the following commands:
  • @flinkbot run azure re-run the last Azure build

flinkbot avatar Mar 23 '23 10:03 flinkbot

hi @twalthr @wuchong do you have time to help review it ?

liuyongvs avatar Mar 24 '23 05:03 liuyongvs

@flinkbot run azure

liuyongvs avatar Mar 25 '23 02:03 liuyongvs