I am trying to use the QueryRecord processor with a SQL statement similar to:
SELECT mi FROM FLOWFILE WHERE CONTAIN_SUBSTR(somedetails, 'Fred') which fails with the following error message in the logs: Caused by org.apache.calcite.runtime.CalciteContextException: From column 31 to line 1, column 66: No match found for function signature CONTAINS_SUBSTR(<CHARACHTER>, <CHARACHTER>) In the Apache Calcite documentation <https://calcite.apache.org/docs/reference.html>I see CONTAINS_SUBSTR defined. Why cannot I use it in NIFI? Are there limitations of what functions that can be used from Apache Calcite?
