Support Questions

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

How to list all sqoop jobs and view the details?

avatar
Contributor

I am not able to list any sqoop jobs despite I run the following command during the sqoop job running time:

 

sqoop job --list

 

Here is a screenshot:

 

Screenshot - 2_2_2018 , 11_09_27 PM.jpg

 

Thank you.

1 ACCEPTED SOLUTION

avatar
Champion

@axie

 

Have you created sqoop job before list? (or) looking for ad hoc sqoop command which are currently running?

 

If you have not created sqoop job then please try this before list

step1: 
sqoop job
--create myjob \--import \--connect jdbc:mysql://localhost/db \ --username root \--table employee --m 1

step 2:
sqoop job --exec myjob

step 3:
sqoop job --list

To get help: sqoop job --help

For more details: https://www.tutorialspoint.com/sqoop/sqoop_job.htm

 

If you are running sqoop in ad hoc basis without job, it may not be listed. Ex:

sqoop import \--connect jdbc:mysql://localhost/db \
--username root \--table employee --m 1

 

View solution in original post

2 REPLIES 2

avatar
Champion

@axie

 

Have you created sqoop job before list? (or) looking for ad hoc sqoop command which are currently running?

 

If you have not created sqoop job then please try this before list

step1: 
sqoop job
--create myjob \--import \--connect jdbc:mysql://localhost/db \ --username root \--table employee --m 1

step 2:
sqoop job --exec myjob

step 3:
sqoop job --list

To get help: sqoop job --help

For more details: https://www.tutorialspoint.com/sqoop/sqoop_job.htm

 

If you are running sqoop in ad hoc basis without job, it may not be listed. Ex:

sqoop import \--connect jdbc:mysql://localhost/db \
--username root \--table employee --m 1

 

avatar
Contributor
Thank you.