have data in kafka topic and able to fetch it with scheduler but later want to put data in a table with different column names. how to do this with scheduler?
please use the instructions from the following link. It has an example regarding sample target table web_hits
You can achieve what you want using flex tables I guess.
1) load data into flex table using scheduler
2) create your destination table with desired columns and copy the data to your destination table using the steps in the below link
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/FlexTables/InsertingDataIntoFlexTables.htm?tocpath=Using Flex Tables|_____5
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.