Support Questions
Find answers, ask questions, and share your expertise

changing metastore in sqoop

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

Accepted Solutions

Super 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

Super 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

Expert Contributor
@Kuldeep Kulkarni

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

Super 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

Mentor

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

Expert Contributor

Sure. get it .

@ Simran Kaur,

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