Sqoop import failed Java.lang.RuntimeException: Can't parse input data:


#1

Can you please check this. Not able to find the reason why it failed

http://rm01.itversity.com:19888/jobhistory/attempts/job_1528589352821_31352/m/FAILED

Error: java.io.IOException: Can't export data, please check failed map task logs at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:122) at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:39) at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:146) at org.apache.sqoop.mapreduce.AutoProgressMapper.run(AutoProgressMapper.java:64) at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:787) 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:422) at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1724) at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:162) Caused by: java.lang.RuntimeException: Can't parse input data: '5747965300' at subrudata_stocks_revenue_monthly.__loadFromFields(subrudata_stocks_revenue_monthly.java:316) at subrudata_stocks_revenue_monthly.parse(subrudata_stocks_revenue_monthly.java:254) at org.apache.sqoop.mapreduce.TextExportMapper.map(TextExportMapper.java:89) ... 10 more Caused by: java.lang.NumberFormatException: For input string: "5747965300" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Integer.parseInt(Integer.java:583) at java.lang.Integer.valueOf(Integer.java:766) at subrudata_stocks_revenue_monthly.__loadFromFields(subrudata_stocks_revenue_monthly.java:313) ... 12 more

#2

Maximum value that can be stored in an integer is 2147483647 but you are passing 5747965300.


#3

Thanks. it helped. Abl;e to resolve it.