UDFs vs ORACLE Procedures
I am new to Vertica. So far I understand that Stored/external procedures and functions in Vertica do not offer the equivalent complexity/functionality as offered by ORACLE stored procedures and functions.
However, Vertica do offer to create UDFs, which can be written in JAVA/Python/R. I am not sure to which extent UDFs support the sql operations.
I have two questions regarding UDFs =>
Do the UDFs offer the same complexity such as - Table joins, Returning Multi-row cursors in the same way as ORACLE procedures do ?
I am trying to explore options to develop functions in JAVA is there any step by step instruction to create UDFs using an IDE like Eclipse ?