[
https://issues.apache.org/jira/browse/DRILL-5362?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15929432#comment-15929432
]
Khurram Faraaz commented on DRILL-5362:
---------------------------------------
works with out parentheses
{noformat}
0: jdbc:drill:schema=dfs.tmp> select CURRENT_TIME FROM (values(1));
+---------------+
| CURRENT_TIME |
+---------------+
| 05:16:33.698 |
+---------------+
1 row selected (0.264 seconds)
{noformat}
> CURRENT_TIME() documented, but not actually available in Drill
> --------------------------------------------------------------
>
> Key: DRILL-5362
> URL: https://issues.apache.org/jira/browse/DRILL-5362
> 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_TIME() function. Tried the following query:
> {code}
> SELECT CURRENT_TIME() FROM (VALUES(1))
> {code}
> Got the following errors:
> {code}
> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: No match found
> for function signature CURRENT_TIME()
> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1,
> column 8 to line 1, column 21: No match found for function signature
> CURRENT_TIME()
> {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)
