04-14-2017 06:29 AM
I am importing teradata table to hive using sqoop import. If there is a change in source table structure (few columns are added in teradata table), is there is way to automatically incorporate the changes in hive using sqoop?
Example. During initial import, say 5 columns are present in teradata table. Later a column is added in teradata. Now, i want this newly added column to be added automatically in hive. So, is there a way to acheive this? IF i use --hive-import, will the table structure change automatically? Please confirm.