Chun Chang created DRILL-2388: --------------------------------- Summary: support extract(epoch) Key: DRILL-2388 URL: https://issues.apache.org/jira/browse/DRILL-2388 Project: Apache Drill Issue Type: Improvement Components: SQL Parser Affects Versions: 0.8.0 Reporter: Chun Chang Assignee: Aman Sinha Priority: Minor
Postgres supports the following: {code} SELECT extract(epoch FROM now()); {code} Drill will error: {code} 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) {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)