[ https://issues.apache.org/jira/browse/PHOENIX-3682?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ankit Singhal reassigned PHOENIX-3682: -------------------------------------- Assignee: (was: Rajeshbabu Chintaguntla) > CURRENT_DATE and CURRENT_TIME cannot be resolved in Phoenix-Calcite > ------------------------------------------------------------------- > > Key: PHOENIX-3682 > URL: https://issues.apache.org/jira/browse/PHOENIX-3682 > Project: Phoenix > Issue Type: Sub-task > Reporter: Rajeshbabu Chintaguntla > Labels: calcite > > {noformat} > testCurrentTimeWithProjectedTable(org.apache.phoenix.end2end.DateTimeIT) > Time elapsed: 7.013 sec <<< ERROR! > java.sql.SQLException: Error while executing SQL "select /*+ > USE_SORT_MERGE_JOIN */ op.id, current_time() from T000014 op where op.id in > (select id from T000015)": From line 1, column 42 to line 1, column 55: No > match found for function signature CURRENT_TIME() > at > org.apache.phoenix.end2end.DateTimeIT.testCurrentTimeWithProjectedTable(DateTimeIT.java:786) > Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, > column 42 to line 1, column 55: No match found for function signature > CURRENT_TIME() > at > org.apache.phoenix.end2end.DateTimeIT.testCurrentTimeWithProjectedTable(DateTimeIT.java:786) > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: No match > found for function signature CURRENT_TIME() > at > org.apache.phoenix.end2end.DateTimeIT.testCurrentTimeWithProjectedTable(DateTimeIT.java:786) > {noformat} > {noformat} > testCurrentDateWithNoTable(org.apache.phoenix.end2end.DateTimeIT) Time > elapsed: 2.367 sec <<< ERROR! > java.sql.SQLException: Error while executing SQL "SELECT CURRENT_DATE()": > From line 1, column 8 to line 1, column 21: No match found for function > signature CURRENT_DATE() > at > org.apache.phoenix.end2end.DateTimeIT.testCurrentDateWithNoTable(DateTimeIT.java:744) > Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, > column 8 to line 1, column 21: No match found for function signature > CURRENT_DATE() > at > org.apache.phoenix.end2end.DateTimeIT.testCurrentDateWithNoTable(DateTimeIT.java:744) > Caused by: org.apache.calcite.sql.validate.SqlValidatorException: No match > found for function signature CURRENT_DATE() > at > org.apache.phoenix.end2end.DateTimeIT.testCurrentDateWithNoTable(DateTimeIT.java:744) > {noformat} -- This message was sent by Atlassian JIRA (v6.3.15#6346)