[DRILL-5363] Invalid

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Not A Problem
• Assignee: Unassigned
• Reporter: Paul Rogers
• Created: 17/Mar/17 04:36
• Updated: 17/Mar/17 21:50
• Resolved: 17/Mar/17 21:50

Description

The Drill documentation describes a CURRENT_TIMESTAMP() function. Tried the following query:

SELECT CURRENT_TIMESTAMP() FROM (VALUES(1))

Got the following errors:

SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature CURRENT_TIMESTAMP()
SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 26: No match found for function signature CURRENT_TIMESTAMP()

Please:

• Implement the function, or
• Remove the function from the documentation, or
• Leave the function in the docs, but add a footnote saying that the function is not yet available.

Note that Drill provides a NOW() function which does work and would seem to do exactly the same as the non-existent CURRENT_TIMESTAMP() function.