[DRILL-2388] support extract(epoch)

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 0.8.0
• Fix Version/s: Future
• Component/s: SQL Parser
• Assignee: Unassigned
• Reporter: Chun Chang
• Created: 05/Mar/15 01:45
• Updated: 24/Jun/21 09:48

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)

Issue Links

• Is contained by: DRILL-4550 Add support more time units in extract function