drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Rogers (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-5363) CURRENT_TIMESTAMP() documented, but not actually available in Drill
Date Fri, 17 Mar 2017 06:32:42 GMT

    [ https://issues.apache.org/jira/browse/DRILL-5363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15929478#comment-15929478
] 

Paul Rogers commented on DRILL-5363:
------------------------------------

Note that the documentation claims that the following should work:

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

However, when run, Drill treats {{CURRENT_TIMESTAMP}} as a column name and returns a null
value.

> 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)

Mime
View raw message