[PHOENIX-3682] CURRENT_DATE and CURRENT_TIME cannot be resolved in Phoenix-Calcite

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Labels: calcite
• Assignee: Unassigned
• Reporter: Rajeshbabu Chintaguntla
• Created: 16/Feb/17 05:33
• Updated: 28/Apr/17 06:30
• Resolved: 28/Apr/17 06:30

Description

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)

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)