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 < [email protected]> 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 >
