Vertica UDF Input / Output Questions

Said_Montiel

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

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

Ashish1

Guys,

 

I am currently working on Vertica DB. Kindly let me know how to output the contents of a table in JSON format.

 

Best,

Ashish