Sqoop import error using oozie


#1

Hi,
Getting following error while running sqoop job.

2018-07-28 07:11:39,636 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@:start:] Start action [0000013-180609032532412-oozie-oozi-W@:start:] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-07-28 07:11:39,636 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@:start:] [***0000013-180609032532412-oozie-oozi-W@:start:***]Action status=DONE
2018-07-28 07:11:39,636 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@:start:] [***0000013-180609032532412-oozie-oozi-W@:start:***]Action updated in DB!
2018-07-28 07:11:39,750 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W
2018-07-28 07:11:39,750 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@:start:] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W@:start:
2018-07-28 07:11:39,777 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@hdfsCommands] Start action [0000013-180609032532412-oozie-oozi-W@hdfsCommands] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-07-28 07:11:39,926 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@hdfsCommands] [0000013-180609032532412-oozie-oozi-W@hdfsCommands]Action status=DONE
2018-07-28 07:11:39,926 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@hdfsCommands] [0000013-180609032532412-oozie-oozi-W@hdfsCommands]Action updated in DB!
2018-07-28 07:11:40,081 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] Start action [0000013-180609032532412-oozie-oozi-W@sqoop-action1] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-07-28 07:11:41,973 INFO SqoopActionExecutor:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] Trying to get job [job_1528589352821_33204], attempt [1]
2018-07-28 07:11:41,992 INFO SqoopActionExecutor:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] checking action, hadoop job ID [job_1528589352821_33204] status [RUNNING]
2018-07-28 07:11:41,994 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] [0000013-180609032532412-oozie-oozi-W@sqoop-action1]Action status=RUNNING
2018-07-28 07:11:41,994 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] [0000013-180609032532412-oozie-oozi-W@sqoop-action1]Action updated in DB!
2018-07-28 07:11:42,022 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W@sqoop-action1
2018-07-28 07:11:42,022 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@hdfsCommands] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W@hdfsCommands
2018-07-28 07:11:53,574 INFO CallbackServlet:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] callback for action [0000013-180609032532412-oozie-oozi-W@sqoop-action1]
2018-07-28 07:11:53,693 INFO SqoopActionExecutor:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] Trying to get job [job_1528589352821_33204], attempt [1]
2018-07-28 07:11:53,846 INFO SqoopActionExecutor:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] Hadoop Jobs launched : []
2018-07-28 07:11:53,847 INFO SqoopActionExecutor:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] action completed, external ID [job_1528589352821_33204]
2018-07-28 07:11:53,850 WARN SqoopActionExecutor:523 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
2018-07-28 07:11:53,923 INFO ActionEndXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] ERROR is considered as FAILED for SLA
2018-07-28 07:11:54,021 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@kill] Start action [0000013-180609032532412-oozie-oozi-W@kill] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2018-07-28 07:11:54,021 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@kill] [0000013-180609032532412-oozie-oozi-W@kill]Action status=DONE
2018-07-28 07:11:54,022 INFO ActionStartXCommand:520 - SERVER[nn01.itversity.com] USER[yuvrajajabe] GROUP[-] TOKEN[] APP[WorkFlowForHDFS] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@kill] [0000013-180609032532412-oozie-oozi-W@kill]Action updated in DB!
2018-07-28 07:11:54,340 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@kill] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W@kill
2018-07-28 07:11:54,340 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[0000013-180609032532412-oozie-oozi-W@sqoop-action1] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W@sqoop-action1
2018-07-28 07:11:54,340 INFO WorkflowNotificationXCommand:520 - SERVER[nn01.itversity.com] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000013-180609032532412-oozie-oozi-W] ACTION[] No Notification URL is defined. Therefore nothing to notify for job 0000013-180609032532412-oozie-oozi-W