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?
Question
column mapping after data with scheduler
+1please use the instructions from the following link. It has an example regarding sample target table web_hits
I have set up a scheduler and it is working fine with the table having same column names as in source table( and the column names in the data in kafka topic). The thing is, the actual aim is to put the kafka data ( from one table) to another table having different column names. How to tell scheduler( which is fetching data from kafka) to map columns. Can i even do it with scheduler? What are the other options?
+1You 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
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
