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

Hello,

 

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.

Comments

  • 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
Emoji
Image
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.