Support Questions
Find answers, ask questions, and share your expertise

Sqoop import command to overwrite the existing table

New Contributor



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: 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.

Expert Contributor

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