sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jayanthi R (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3193) Sqoop comamnd to overwrite the table
Date Tue, 06 Jun 2017 09:32:18 GMT
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

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

View raw message