Welcome to the Cloudera Community

Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Sqoop import: Changing table structure

avatar
Explorer

 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.

Who agreed with this topic