Loading data Vertica to Vertica
I need to load data from a SELECT from Vertica to VERTICE itself.
If I use an ETL tool to capture the data and later save the data in Vertica I will face a network process that I do not want. The alternative to this was to create an "INSERT INTO TABLE SELECT" script, however, so the load information in the "load_streams" table is not written. Is there any way to write data from a SELECT from within Vertica and that the loader generates information in the "load_streams" table?
COPY FROM VERTICA SELECT