Creating external procedures

Moderator: NorbertKrupa

Post Reply
sushanth
Newbie
Newbie
Posts: 6
Joined: Wed Sep 25, 2013 6:59 am

Creating external procedures

Post by sushanth » Mon Oct 21, 2013 10:13 am

Hi All,

I am new to vertica and got to know that there is no support for stored procedures in vertica and instead we can create external procedures and add it to vertica.

Please provide me a step by step instructions for how to create an external script and add it to vertica.

My requirement is to select all records from an employee table where empid is some value and empid is passed as an parameter.

So how to create a script for this and add it to vertica.

I need to know

1. How to create the the external script
2. Add the script/procedure to vertica
3. How to call the procedure in vertica so that i will get the desired output.

Thanks in Advance
Sushanth.B

User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Re: Creating external procedures

Post by nnani » Wed Oct 23, 2013 2:32 pm

#Sushanth

You can refer to this link

https://my.vertica.com/docs/6.1.x/HTML/ ... #13587.htm

Also, You can refer to this example on forums

viewtopic.php?f=63&t=1329&p=4316&hilit= ... dure#p4316

Hope this helps.. :)
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica External Procedures”