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 linkhttps://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/FlexTables/InsertingDataIntoFlexTables.htm?tocpath=Using Flex Tables|_____5