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-5361) CURRENT_DATE() documented, but not actually available in Drill
Date Fri, 17 Mar 2017 16:13:41 GMT

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

Paul Rogers commented on DRILL-5361:

Our documentation list all functions without parens. {{NOW()}} is listed as {{NOW}} (no parens),
I had to figure out it needed parens. So, when I tried {{CURRENT_DATE}}, I added parens.

As was suggested, maybe just change the doc to show if parens are required or no parens are


Or, just allow people to experiment and learn the hard way as I have, or rely on prior knowledge
as Zelaine has.

Would be nice to make parens optional, but that is a very low priority request.

> CURRENT_DATE() documented, but not actually available in Drill
> --------------------------------------------------------------
>                 Key: DRILL-5361
>                 URL: https://issues.apache.org/jira/browse/DRILL-5361
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.10.0
>            Reporter: Paul Rogers
> The [Drill documentation|http://drill.apache.org/docs/date-time-functions-and-arithmetic/]
describes a CURRENT_DATE() function. Tried the following query:
> {code}
> {code}
> Got the following errors:
> {code}
> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: No match found for function
signature CURRENT_DATE()
> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to
line 1, column 21: No match found for function signature CURRENT_DATE()
> {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.

This message was sent by Atlassian JIRA

View raw message