Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-23899 Built-in SQL Function Improvement
  3. SPARK-23903

Add support for date extract

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 2.3.0
    • 2.4.0
    • SQL
    • None

    Description

      Heavily used in timeseries based datasets. 

      https://www.postgresql.org/docs/9.1/static/functions-datetime.html#FUNCTIONS-DATETIME-EXTRACT

      EXTRACT(field FROM source)

       

      Attachments

        Issue Links

          relates to

          Sub-task - The sub-task of the issue SPARK-28623 Support `dow`, `isodow` and `doy` at `extract()`

          • Major - Major loss of function.
          • Resolved

          Sub-task - The sub-task of the issue SPARK-28656 Support `millennium`, `century` and `decade` at `extract()`

          • Major - Major loss of function.
          • Resolved
          links to

          Pull request #21479 [Github] Pull Request #21479 (wangyum)

          Web Link GitHub Pull Request #21479

          Activity

            People

              yumwang Yuming Wang
              smilegator Xiao Li
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: