[jira] [Created] (DRILL-5363) CURRENT_TIMESTAMP() documented, but not actually available in Drill

["Paul Rogers (JIRA)" <ji...@apache.org>]

Paul Rogers created DRILL-5363:
----------------------------------

             Summary: CURRENT_TIMESTAMP() documented, but not actually available in Drill
                 Key: DRILL-5363
                 URL: https://issues.apache.org/jira/browse/DRILL-5363
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Paul Rogers


The [Drill documentation|http://drill.apache.org/docs/date-time-functions-and-arithmetic/] describes a CURRENT_TIMESTAMP() function. Tried the following query:

{code}
SELECT CURRENT_TIMESTAMP() FROM (VALUES(1))
{code}

Got the following errors:

{code}
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()
{code}

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.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)