Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Sqoop import command to overwrite the existing table

avatar
New Contributor

@jayanthir

2 REPLIES 2

avatar

Hi @Jayanthi R all you need to do is use the --hive-overwrite option in your sqoop import statement. Check the sqoop documentation for more advice: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_importing_data_into_hive You will see a list of options in Table 8 that you can use when you import data into Hive.

If you're already tried this, can you let us know if you're having problems? If so, please paste the full error message.

avatar
Expert Contributor

If the target table is Hive table then you can use -hive-overwrite