You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/03/17 04:37:41 UTC

[jira] [Updated] (DRILL-5361) CURRENT_DATE() documented, but not actually available in Drill

     [ https://issues.apache.org/jira/browse/DRILL-5361?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Rogers updated DRILL-5361:
-------------------------------
    Description: 
The [Drill documentation|http://drill.apache.org/docs/date-time-functions-and-arithmetic/] describes a CURRENT_DATE() function. Tried the following query:

{code}
SELECT CURRENT_DATE() FROM (VALUES(1))
{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.

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

{code}
SELECT CURRENT_DATE() FROM (VALUES(1))
{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.


> 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}
> SELECT CURRENT_DATE() FROM (VALUES(1))
> {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
(v6.3.15#6346)