Uploaded image for project: 'Phoenix'
  1. Phoenix
  2. PHOENIX-3104 Enable Phoenix test cases with Calcite-Phoenix
  3. PHOENIX-3682

CURRENT_DATE and CURRENT_TIME cannot be resolved in Phoenix-Calcite

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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)
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              rajeshbabu Rajeshbabu Chintaguntla
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: