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

support extract(epoch)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 0.8.0
    • Future
    • SQL Parser
    • None

    Description

      Postgres supports the following:

      SELECT extract(epoch FROM now());

      Drill will error:

      0: jdbc:drill:schema=dfs.drillTestDirComplexJ> SELECT extract(epoch FROM now()) from sys.drillbits;
Query failed: ParseException: Encountered "epoch" at line 1, column 16.
Was expecting one of:
    "YEAR" ...
    "MONTH" ...
    "DAY" ...
    "HOUR" ...
    "MINUTE" ...
    "SECOND" ...


Error: exception while executing query: Failure while executing query. (state=,code=0)

      Attachments

        Issue Links

          Is contained by

          Improvement - An improvement or enhancement to an existing feature or task. DRILL-4550 Add support more time units in extract function

          • Major - Major loss of function.
          • Open

          Activity

            People

              Unassigned Unassigned
              cchang@maprtech.com Chun Chang
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: