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] <
ml+s70518n14753...@n6.nabble.com> 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
> ml+s70518n1...@n6.nabble.com
> To unsubscribe from Apache Ignite Users, click here
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code=1=YWxleGFuZGVyLmZlZG90b2ZmQGdtYWlsLmNvbXwxfC0xMzYxNTU0NTg=>
> .
> NAML
> <http://apache-ignite-users.70518.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer=instant_html%21nabble%3Aemail.naml=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace=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.