changing metastore in sqoop

[#1]

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?

[#2 · Accepted solution]

@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.

[#3]

@Kuldeep Kulkarni

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

[#4]

@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

[#5]

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

[#6]

Sure. get it .

[#7]

@ Simran Kaur,

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