Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4550

Add support more time units in extract function

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 1.6.0
    • Future
    • Functions - Drill
    • None

    Description

      Currently extract function support following units YEAR, MONTH, DAY, HOUR, MINUTE, SECOND. Add support for more units: CENTURY, DECADE, DOW, DOY, EPOCH, MILLENNIUM, QUARTER, WEEK.

      We also need changes in the SQL parser. Currently the parser only allows YEAR, MONTH, DAY, HOUR, MINUTE, SECOND as units.

      Attachments

        Issue Links

          contains

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-2388 support extract(epoch)

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open
          depends upon

          Improvement - An improvement or enhancement to an existing feature or task. CALCITE-1177 Support more time units in EXTRACT function

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

          Web Link GitHub Pull Request #453

          Activity

            People

              vkorukanti Venki Korukanti
              vkorukanti Venki Korukanti
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: