Hi, If you have defined a custom function according to the https://apacheignite.readme.io/docs/miscellaneous-features#section-custom-sql-functions then to use it from H2 console you need to prefix it with the schema name of the cache where you have registered your function, for example: *SELECT YOURSCHEMA.sqr(4) FROM YOURSCHEMA.SOMETABLE*
Kind regards, Alex. On Thu, Jul 13, 2017 at 11:35 AM, Lucky [via Apache Ignite Users] < [email protected]> wrote: > Hi: > > As some reason,I must utilize custom function in query sql . > > Just like this: select myId('myRule'),sname from tableA > > I have define the custom function 'myid' with java code . > > And it work running on client node. > But when I run the sql in H2 Console, it got the wrong message: > function 'myId' not found. > Do it support in H2 console ? > > > > > > > > > > > > ------------------------------ > If you reply to this email, your message will be added to the discussion > below: > http://apache-ignite-users.70518.x6.nabble.com/Execute- > Custom-function-in-H2-Console-tp14753.html > To start a new topic under Apache Ignite Users, email > [email protected] > To unsubscribe from Apache Ignite Users, click here > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=1&code=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=> > . > NAML > <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml> > -- View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Execute-Custom-function-in-H2-Console-tp14753p14933.html Sent from the Apache Ignite Users mailing list archive at Nabble.com.
