@Pradeep Allu are you still having issues with this? Can you accept the best answer or post your solution? ... View more

try it out and blog about it here. I'm sure people will find it valuable. The other thing I just thought of is you can write a script that will constantly ping the metastore and send email if it's down. I've done that to check for firewall status. I feel your pain and I was in the same boat. You can look at Attunity Replicate or Golden Gate for CDC solution and not rely on sqoop incremental jobs. @Luis Antonio Torres ... View more

@Robin Dong has this been resolved? Can you provide a solution or accept the best answer? ... View more

@Kuldeep Kulkarni has this been resolved? Can you provide a solution or accept the best answer? ... View more

@rbalam has this been resolved? Can you provide a solution or accept the best answer? ... View more

@David Yee has this been resolved? Can you provide a solution or accept the best answer? ... View more

unfortunately I don't know of any built-in solution to run it as a service at least in 1.x line. What I have been doing was putting sqoop metastore service in background. YOu'd do that by issuing your command "sqoop metastore &" you can also run screen and run sqoop metastore in screen session and detach from it. Of course you have no idea if it goes down until jobs start failing. There was a promise to have metastore running in a relational database but I haven't heard anything yet. @Luis Antonio Torres ... View more

excellent, you beat me by 5min, I was about to point you to the doc for that. I should've looked at your workflow more carefully. @Luis Antonio Torres ... View more

Yep looking forward to trying it @Enis ... View more

@S Roy try @Benjamin Leonhardi solution ... View more