New Contributor
Posts: 6
Registered: ‎04-03-2017

Sqoop import: Changing table structure

 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.

New Solutions