Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Store results within an User Defined Transform Function into a temorary table



i was wondering if there is any way to store the results of an User Defined Tronsform Function directly into a temorary table using the C++ API to avoid another Insert SQL Statement and to encapsulate everything inside the UDx.


  • Hello, Vincon.


    Have you tried the INSERT SELECT statement?


    You can take any SELECT statement and use it to generate values that are inserted into a table with a matching schema. You can even use "CREATE TABLE AS SELECT" (also known as "CTAS") to have this done automatically.


    - Derrick

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.