Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here. Want to know more about what has changed? Check out the Community News blog.

How to list all sqoop jobs and view the details?

SOLVED Go to solution

How to list all sqoop jobs and view the details?

Explorer

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

Accepted Solutions
Highlighted

Re: How to list all sqoop jobs and view the details?

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

 

2 REPLIES 2
Highlighted

Re: How to list all sqoop jobs and view the details?

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

 

Re: How to list all sqoop jobs and view the details?

Explorer
Thank you.