[SQOOP-3193] Sqoop comamnd to overwrite the table

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.7
• Fix Version/s: no-release
• Labels: features

Environment

linux

• Flags: Important
• Assignee: Unassigned
• Reporter: Jayanthi R
• Created: 06/Jun/17 09:32
• Updated: 06/Jul/17 09:44

Description

I am using sqoop import command and I want to overwrite the data when I use it for second or third time (except the first time)

sqoop import --connect jdbc:postgresql://reuxeuls677.bp.com/auditdb --username audit_user --password theaudituserloginpassword --table test_automation --hive-overwrite --hive-table sqoophive -m 1 --hive-import --hive-database 'test_automation_db' --create-hive-table --hive-table test_automation;

But, I am getting the following error:

17/06/06 09:34:13 ERROR tool.ImportTool: Encountered IOException running import job: org.apache.hadoop.mapred.FileAlreadyExistsException: Output directory hdfs://HDPEMDCPROD/user/dluser/test_automation already exists