[jira] [Commented] (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:comment-tabpanel=15930328#comment-15930328
]
Paul Rogers commented on DRILL-5361:
Part of problem tracked down to the fact that when used properly (without
parens) the query includes a sort and project. (Se DRILL-5364.) These hit some
bug that caused the value to be removed (that, in fact, was the purpose of this
effort - to test the sort, but this query was supposed to not need the sort...)
Cancelling this JIRA.
> 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)
[jira] [Commented] (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:comment-tabpanel=15930260#comment-15930260
]
Zelaine Fong commented on DRILL-5361:
-
In that case, would it make sense to change this issue to a Doc bug to make
things more clear?
BTW, if you click on the NOW link on the doc page you referenced, it takes you
to
http://drill.apache.org/docs/date-time-functions-and-arithmetic/#other-date-and-time-functions.
On this page, the examples do show the cases where you need parens and the
cases where you don't.
> 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)
[jira] [Commented] (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:comment-tabpanel=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 required.
{code}
NOW()
CURRENT_DATE
{code}
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}
> 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)
[jira] [Commented] (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:comment-tabpanel=15930114#comment-15930114
]
Zelaine Fong commented on DRILL-5361:
-
[~khfaraaz] - that's the intended behavior -- no parens. This is consistent
with Postgres and other DBMS's. Not sure why [~Paul.Rogers] expected this to
work with the parens.
> 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)
[jira] [Commented] (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:comment-tabpanel=15929428#comment-15929428
]
Khurram Faraaz commented on DRILL-5361:
---
The below usage of CURRENT_DATE without open and close parentheses gives
results. Not sure if this is a documentation issue or if this is a design issue.
This is from Drill 1.10.0
{noformat}
0: jdbc:drill:schema=dfs.tmp> select CURRENT_DATE FROM (values(1));
+---+
| CURRENT_DATE |
+---+
| 2017-03-17|
+---+
1 row selected (0.392 seconds)
{noformat}
> 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)
