You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Brian Vanover (JIRA)" <ji...@apache.org> on 2016/02/17 19:47:18 UTC

[jira] [Created] (SQOOP-2842) Sqoop import job fails on large table

Brian Vanover created SQOOP-2842:
------------------------------------

             Summary: Sqoop import job fails on large table
                 Key: SQOOP-2842
                 URL: https://issues.apache.org/jira/browse/SQOOP-2842
             Project: Sqoop
          Issue Type: Bug
          Components: sqoop2-hdfs-connector, sqoop2-jdbc-connector, sqoop2-shell
    Affects Versions: 1.99.6
         Environment: OS X Yosemite 10.10.5, Sqoop 1.99.6, Hadoop 2.7.2 (Homebrew installation), Oracle 11 
            Reporter: Brian Vanover
             Fix For: 1.99.6


I am prototyping migration of a large record set generated by a computationally expensive custom query. This query takes approximately 1-2 hours to return a result set in SQL Developer

I am attempting to pass this query to a simple Sqoop job with links JDBC to HDFS

I have encountered the following errors in my logs:

2016-02-12 10:15:50,690 ERROR mr.SqoopOutputFormatLoadExecutor [org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:257)] Error while loading data out of MR job. org.apache.sqoop.common.SqoopException: GENERIC_HDFS_CONNECTOR_0005:Error occurs during loader run at org.apache.sqoop.connector.hdfs.HdfsLoader.load(HdfsLoader.java:110) at org.apache.sqoop.connector.hdfs.HdfsLoader.load(HdfsLoader.java:41) at org.apache.sqoop.job.mr.SqoopOutputFormatLoadExecutor$ConsumerThread.run(SqoopOutputFormatLoadExecutor.java:250) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.hdfs.server.namenode.LeaseExpiredException): No lease on /user/username/schema/recordset/.72dee005-3f75-4a95-bbc0-30c6b565d193/f5aeeecc-097e-49ab-99cc-b5032ae18a84.txt (inode 16415): File does not exist. [Lease. Holder: DFSClient_NONMAPREDUCE_-1820866823_31, pendingcreates: 1]

When I try to check the resulting .txt files in my hdfs, they are empty.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)