Vertica UDF Input / Output Questions

Forum|Forum|12 years ago
August 7, 2014
2 replies
16 views

+1

Said_Montiel
Participating Frequently

I wanted to know possibilities on Input and Output for Vertica R UDF

Inputs
* Can I send more than 1 table as input? Let's say I need 2 unrelated tables as input

Ouptut
* Can I output a table with 1 col 1 row with a JSON formatted TEXT (or VARCHAR)?
* Is there a limit on the amount of characters recognized by a VARCHAR in vertica?

Thanks

PRana
Participating Frequently
Forum|Forum|12 years ago
August 7, 2014

HI Said,

The UDx cannot take input from more than 1 table at present. You can output a table with 1 col and 1 row with JSON formatted text. A VARCHAR can take strings of upto 65000 charaters. You might wat to use LONG VARCHAR for longer strings which can store upto 32,000,000 bytes.

Thanks
Pratibha