Vertica UDF Input / Output Questions
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
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
0
Comments
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
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