implementing business logic in Vertica

jumanji

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
   2. 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.

jumanji

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?