Jayanthi R created SQOOP-3193: --------------------------------- Summary: Sqoop comamnd to overwrite the table Key: SQOOP-3193 URL: https://issues.apache.org/jira/browse/SQOOP-3193 Project: Sqoop Issue Type: Bug Components: sqoop2-shell Affects Versions: 1.99.7 Environment: linux Reporter: Jayanthi R Fix For: no-release
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 -- This message was sent by Atlassian JIRA (v6.3.15#6346)