[SQOOP-3016] warehouse-dir or target-dir is not being honored

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.4.5
• Component/s: connectors/hdfs

Environment

CDH 5.4.7

• Assignee: Unassigned
• Reporter: Kingsly J
• Created: 29/Sep/16 13:54
• Updated: 02/Mar/17 12:44

Description

Hi Team,
In our QA env, we are not having sudo access and not having folder in our username in "/user" and not having write access to the same. Hence we used --warhouse-dir to direct the result to the directory for which we are having write access.we tried the below sqoop statement to load data from Teradata to hdfs,
sqoop import --connect jdbc:teradata://<ip>/Database=test,LOGMECH=LDAP --username abc -P --table tbl1 --split-by tbl_cd --warehouse-dir /projects/Sqoop_Test

but getting the below error,
ERROR tool.ImportTool: Encountered IOException running import job: com.teradata.connector.common.exception.ConnectorException: org.apache.hadoop.security.AccessControlException: Permission denied: user=abc, access=WRITE, inode="/user":hdfs:supergroup:drwxr-xr-x

It is still trying to write to "/user" path. we have tried with --target-dir parameter also, and still getting the same error.

Please guide us on the same.

Regards,
Kingsly J