problem creating user defined function

[Prathamesh Junnarkar <pr...@cybage.com>]

Hi Team,

I want to create custom function in apache phoenix.
But I am facing problems while running command to create function.
Command:
> CREATE FUNCTION ADDNUM(INTEGER,INTEGER) returns INTEGER as 'phoenix.udf.AddNumber'

Exception:

SQL Error [601] [42P00]: ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column 8.
ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column 8.
org.antlr.runtime.NoViableAltException: NoViableAltException

Can you please help me how can I proceed with creating UDF.

Regards,
Prathamesh Junnarkar


"Legal Disclaimer: This electronic message and all contents contain information from Cybage Software Private Limited which may be privileged, confidential, or otherwise protected from disclosure. The information is intended to be for the addressee(s) only. If you are not an addressee, any disclosure, copy, distribution, or use of the contents of this message is strictly prohibited. If you have received this electronic message in error please notify the sender by reply e-mail to and destroy the original message and all copies. Cybage has taken every reasonable precaution to minimize the risk of malicious content in the mail, but is not liable for any damage you may sustain as a result of any malicious content in this e-mail. You should carry out your own malicious content checks before opening the e-mail or attachment." www.cybage.com

Re: problem creating user defined function

[James Taylor <ja...@apache.org>]

Hi Prathamesh,
What version of Phoenix are you using? I suspect you're using a pre-4.4.0
release, as UDFs are only supported from 4.4.0 onward.
Thanks,
James

On Fri, Sep 18, 2015 at 5:05 AM, Prathamesh Junnarkar <
prathameshju@cybage.com> wrote:

> Hi Team,
>
> I want to create custom function in apache phoenix.
> But I am facing problems while running command to create function.
> Command:
> > CREATE FUNCTION ADDNUM(INTEGER,INTEGER) returns INTEGER as
> 'phoenix.udf.AddNumber'
>
> Exception:
>
> SQL Error [601] [42P00]: ERROR 601 (42P00): Syntax error. Encountered
> "FUNCTION" at line 1, column 8.
> ERROR 601 (42P00): Syntax error. Encountered "FUNCTION" at line 1, column
> 8.
> org.antlr.runtime.NoViableAltException: NoViableAltException
>
> Can you please help me how can I proceed with creating UDF.
>
> Regards,
> Prathamesh Junnarkar
>
>
> "Legal Disclaimer: This electronic message and all contents contain
> information from Cybage Software Private Limited which may be privileged,
> confidential, or otherwise protected from disclosure. The information is
> intended to be for the addressee(s) only. If you are not an addressee, any
> disclosure, copy, distribution, or use of the contents of this message is
> strictly prohibited. If you have received this electronic message in error
> please notify the sender by reply e-mail to and destroy the original
> message and all copies. Cybage has taken every reasonable precaution to
> minimize the risk of malicious content in the mail, but is not liable for
> any damage you may sustain as a result of any malicious content in this
> e-mail. You should carry out your own malicious content checks before
> opening the e-mail or attachment." www.cybage.com
>