I would be happy to incorporate this code into our github extensions repository (https://github.com/vertica/Vertica-Extension-Packages)
For legal reasons, I can not include it unless you sign a contributor license agreement, which is straightforward and easy to do:
Quoting from:
https://github.com/vertica/Vertica-Exte ... README.txt
IMPORTANT: If you wish to contribute anything to this repository, in
order for us to accept your pull request you MUST sign and send a copy
of the appropriate Contributor License Agreement to Vertica
(contribs@vertica.com):
license/PersonalCLA.pdf: If you are contributing for yourself
license/CorporateCLA.pdf: If you are contributing on behalf of your company
File links:
https://github.com/vertica/Vertica-Exte ... nalCLA.pdf
https://github.com/vertica/Vertica-Exte ... ateCLA.pdf
Display a number value in Words
Moderator: NorbertKrupa
Re: Display a number value in Words
sKwa,
Thanks! That's so cool!
Thanks! That's so cool!
Code: Select all
dbadmin=> select spell_number(8) || ' plus ' || spell_number(8) || ' equals ' || spell_number(16) cool
cool
---------------------------------
eight plus eight equals sixteen
(1 row)
Thanks,
Juliette
Juliette
Re: Display a number value in Words
Hi ,
Is there any way to return the output of a python function as an external procedure in Vertica.
I need to create a UUID generator function - and would like to have something that I can embedd in a query: select uuid_gen(), other col from table
Looks like with python I can only return an exit status. (same with uuidgen in shell) there anything else I can do?
thanks,
Dgh
Is there any way to return the output of a python function as an external procedure in Vertica.
I need to create a UUID generator function - and would like to have something that I can embedd in a query: select uuid_gen(), other col from table
Looks like with python I can only return an exit status. (same with uuidgen in shell) there anything else I can do?
thanks,
Dgh
- JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Display a number value in Words
DGh,
You need to ask your question in the "Connecting to Vertica/Python" forum here:
http://www.vertica-forums.com/viewforum.php?f=35
Otherwise no one will read it because it has nothing to do with the original subject in the thread to which you posted your question
You need to ask your question in the "Connecting to Vertica/Python" forum here:
http://www.vertica-forums.com/viewforum.php?f=35
Otherwise no one will read it because it has nothing to do with the original subject in the thread to which you posted your question
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Re: Display a number value in Words
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Sat May 09, 2015 3:32 pm, edited 1 time in total.
Re: Display a number value in Words
Thanks for the UDF skwa.
Re: Display a number value in Words
Thanks Skwa, I figured that out yesterday (that I could only return exist statuses for scripts).sKwa wrote:>> Is there any way to return the output of a python function as an external procedure in Vertica.
No.
Wrote a c++ prog using Boost library and followed your instructions for compiling (new to c++ as well ) and it works like charm!
Thank you all for the help. This forum is a great platform for beginners like me
DGh