Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Sqoop import command to overwrite the existing table

Highlighted

Sqoop import command to overwrite the existing table

New Contributor

@jayanthir

2 REPLIES 2

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?
Coming from Hortonworks? Activate your account here