[ https://issues.apache.org/jira/browse/SQOOP-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Eric Lin updated SQOOP-3193: ---------------------------- Component/s: (was: sqoop2-shell) > Sqoop comamnd to overwrite the table > ------------------------------------ > > Key: SQOOP-3193 > URL: https://issues.apache.org/jira/browse/SQOOP-3193 > Project: Sqoop > Issue Type: Bug > Affects Versions: 1.4.7 > Environment: linux > Reporter: Jayanthi R > Labels: features > 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.4.14#64029)