sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Eric Lin (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-3193) Sqoop comamnd to overwrite the table
Date Thu, 06 Jul 2017 09:45:00 GMT

     [ 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)

Mime
View raw message