Thanks a lot..It really worked like a charm.. import completes successfully.. But getting a error like (ERROR ATTATCHED) Error: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: No more data to read from socket Can you put some light on this cause ? 17/11/14 18:41:54 INFO mapreduce.Job: Running job: job_1510681534788_0007 17/11/14 18:42:02 INFO mapreduce.Job: Job job_1510681534788_0007 running in uber mode : false 17/11/14 18:42:02 INFO mapreduce.Job: map 0% reduce 0% 17/11/14 18:42:30 INFO mapreduce.Job: map 20% reduce 0% 17/11/14 18:43:01 INFO mapreduce.Job: map 40% reduce 0% 17/11/14 18:43:02 INFO mapreduce.Job: map 60% reduce 0% 17/11/14 18:43:14 INFO mapreduce.Job: map 80% reduce 0% 17/11/14 18:43:35 INFO mapreduce.Job: Task Id : attempt_1510681534788_0007_m_000003_0, Status : FAILED Error: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLRecoverableException: No more data to read from socket at org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:167) at org.apache.hadoop.util.ReflectionUtils.setConf(ReflectionUtils.java:76) at org.apache.hadoop.util.ReflectionUtils.newInstance(ReflectionUtils.java:136) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:749) at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341) at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:168) at java.security.AccessController.doPrivileged(Native Method) at javax.security.auth.Subject.doAs(Subject.java:415) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162) Caused by: java.lang.RuntimeException: java.sql.SQLRecoverableException: No more data to read from socket at org.apache.sqoop.mapreduce.db.DBInputFormat.getConnection(DBInputFormat.java:220) at org.apache.sqoop.mapreduce.db.DBInputFormat.setConf(DBInputFormat.java:165) ... 9 more Caused by: java.sql.SQLRecoverableException: No more data to read from socket at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:281) at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:118) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:224) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:296) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:539) at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1091) at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1040) at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:814) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:428) at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:494) ... 10 more 17/11/14 18:43:55 INFO mapreduce.Job: map 100% reduce 0% 17/11/14 18:43:55 INFO mapreduce.Job: Job job_1510681534788_0007 completed successfully 17/11/14 18:43:56 INFO mapreduce.Job: Counters: 31 File System Counters FILE: Number of bytes read=0 FILE: Number of bytes written=750200 FILE: Number of read operations=0 FILE: Number of large read operations=0 FILE: Number of write operations=0 HDFS: Number of bytes read=579 HDFS: Number of bytes written=136 HDFS: Number of read operations=20 HDFS: Number of large read operations=0 HDFS: Number of write operations=10 Job Counters Failed map tasks=1 Launched map tasks=6 Other local map tasks=6 Total time spent by all maps in occupied slots (ms)=310816 Total time spent by all reduces in occupied slots (ms)=0 Total time spent by all map tasks (ms)=310816 Total vcore-seconds taken by all map tasks=310816 Total megabyte-seconds taken by all map tasks=77704000 Map-Reduce Framework Map input records=4 Map output records=4 Input split bytes=579 Spilled Records=0 Failed Shuffles=0 Merged Map outputs=0 GC time elapsed (ms)=6122 CPU time spent (ms)=8900 Physical memory (bytes) snapshot=773640192 Virtual memory (bytes) snapshot=4145668096 Total committed heap usage (bytes)=665845760 File Input Format Counters Bytes Read=0 File Output Format Counters Bytes Written=136 17/11/14 18:43:56 INFO mapreduce.ImportJobBase: Transferred 136 bytes in 125.5593 seconds (1.0832 bytes/sec) 17/11/14 18:43:56 INFO mapreduce.ImportJobBase: Retrieved 4 records. 17/11/14 18:43:56 INFO util.AppendUtils: Appending to directory orders 17/11/14 18:43:56 INFO util.AppendUtils: Using found partition 10 17/11/14 18:43:56 INFO tool.ImportTool: Incremental import complete! To run another incremental import of all data following this import, supply the following arguments: 17/11/14 18:43:56 INFO tool.ImportTool: --incremental lastmodified 17/11/14 18:43:56 INFO tool.ImportTool: --check-column ORDER_TIMESTAMP 17/11/14 18:43:56 INFO tool.ImportTool: --last-value 2017-11-14 19:29:52.0 17/11/14 18:43:56 INFO tool.ImportTool: (Consider saving this with 'sqoop job --create') Will be connecting you whenever getting any issue..You are really a champ..Once again thank you dear.. ... View more

@Shu Thank You very much for your brief explanation making it clear.. Actually i am working on a dummy table without timestamp. Hope this will help me with timestamp column. ... View more