Sorry, right now Ignite uses an older H2 version. I hope we will be able to upgrade it soon, but for now you can go with user defined functions [1].
[1] https://ignite.apache.org/releases/1.8.0/javadoc/org/apache/ignite/cache/query/annotations/QuerySqlFunction.html Sergi 2017-02-28 15:13 GMT+03:00 mrinalkamboj <[email protected]>: > I am trying to use the following query from the .Net client: > > *select _key,OrderId, OrderName, OrderDateTime, OrderValue, OrderAddress > from OrderEntity Where REGEXP_LIKE(OrderAddress,?)* > > Where for the placeholder ?, I supply the valid Regular expression, but > following is exception generated: > > *Caused by: org.h2.jdbc.JdbcSQLException: Function "REGEXP_LIKE" not found; > SQL statement: select _key,OrderId, OrderName, OrderDateTime, OrderValue, > OrderAddress from OrderEntity Where REGEXP_LIKE(OrderAddress,?)* > > I can use the Like operator effectively, as follows, but that's not enough > I > need to do complex regex mapping > > *select OrderId, OrderName, OrderDateTime, OrderValue, OrderAddress from > OrderEntity Where OrderAddress like '%' || ?* > > This also seems to be the case for other H2 database functions available at > the following link > > http://www.h2database.com/html/functions.html > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/How-to-use-H2-database-functions-in- > the-Sql-query-using-Net-APIs-tp10939.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
