question Re: changing metastore in sqoop in Archives of Support Questions (Read Only)

changing metastore in sqoop

sim6 — Sun, 08 May 2016 20:58:42 GMT

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?

Re: changing metastore in sqoop

KuldeepK — Sun, 08 May 2016 21:01:27 GMT

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

Re: changing metastore in sqoop

sim6 — Sun, 08 May 2016 21:09:47 GMT

@Kuldeep Kulkarni

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

Re: changing metastore in sqoop

KuldeepK — Sun, 08 May 2016 21:32:11 GMT

@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

Re: changing metastore in sqoop

aervits — Sun, 08 May 2016 21:32:43 GMT

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

Re: changing metastore in sqoop

sim6 — Sun, 08 May 2016 21:57:43 GMT

Sure. get it .

Re: changing metastore in sqoop

shashang_sheth — Tue, 14 Feb 2017 03:37:28 GMT

@ Simran Kaur,

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