implementing business logic in Vertica

  1. I am planning to write a Java code to fetch some data, do some processing and then go back to DB in the traditional way. But if we have millions of records this will create a problem
    1. Do we have a way, where I can write my business logic using python, SQL or any other language and install it on Vertical and then schedule the trigger externally? So that, once the controls go into DB completes the business logic in one IO.

Comments

  • is there a way, were I can write query to fetch data from one table, process it and then insert the result into other table?

Leave a Comment

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