You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2017/03/17 05:16:41 UTC
[jira] [Commented] (DRILL-5363) CURRENT_TIMESTAMP() documented, but
not actually available in Drill
[ https://issues.apache.org/jira/browse/DRILL-5363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15929430#comment-15929430 ]
Khurram Faraaz commented on DRILL-5363:
---------------------------------------
Same as CURRENT_DATE, CURRENT_TIMESTAMP also works without open and close parentheses.
{noformat}
0: jdbc:drill:schema=dfs.tmp> select CURRENT_TIMESTAMP FROM (values(1));
+--------------------------+
| CURRENT_TIMESTAMP |
+--------------------------+
| 2017-03-17 05:15:07.719 |
+--------------------------+
1 row selected (0.247 seconds)
{noformat}
> 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)