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

Sqoop import command to overwrite the existing table

Sqoop import command to overwrite the existing table

New Contributor

@jayanthir

2 REPLIES 2
Highlighted

Re: Sqoop import command to overwrite the existing table

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.

Highlighted

Re: Sqoop import command to overwrite the existing table

Expert Contributor

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

Don't have an account?