Execute Custom function in H2 Console

[Lucky <wa...@163.com>]

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 ?





 





 

Re: Execute Custom function in H2 Console

[afedotov <al...@gmail.com>]

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+s70518n14753h77@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+s70518n1h65@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&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.