Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

changing metastore in sqoop

avatar
Expert Contributor

I changed metastore for sqoop to a db in MySQL following this post. But , the last step here is

hadoop fs -put /etc/sqoop/conf/sqoop-site.xml /user/oozie/commons/

I see that we do not have a commons folder under oozie. What should I replace it with? Also, Now, I could successfully create a job using metaconnect but when I execute sqoop job -list.

It shows no jobs. I have confirmed that the job that I created exists. Does this have anything to do with change in metastore?

How do I fix this?

1 ACCEPTED SOLUTION

avatar
Master Guru
@simran kaur

You can put sqoop-site.xml in /user/oozie/share/lib/lib-<timestamp>/sqoop/

if sqoop dir is not there then you can create it.

View solution in original post

6 REPLIES 6

avatar
Master Guru
@simran kaur

You can put sqoop-site.xml in /user/oozie/share/lib/lib-<timestamp>/sqoop/

if sqoop dir is not there then you can create it.

avatar
Expert Contributor
@Kuldeep Kulkarni

It still does not show any jobs when I execute sqoop job -list

avatar
Master Guru

@simran kaur - Sorry I forgot to tell you. whenever you update oozie sharelib with new files or any modification in oozie sharelib requires sharelibupdate.

Please run below command on oozie host as oozie user.

oozie admin -oozie http://<oozie-host>:11000/oozie -sharelibupdate

avatar
Master Mentor

Let's keep separate questions in their own threads. This confuses readers.

avatar
Expert Contributor

Sure. get it .

avatar

@ Simran Kaur,

Can you re post the link to setting MYSQL as metastore for Sqoop. The above link is broken.