in Big Data | Hadoop by
Q:

Explain about some important Sqoop commands other than import and export.

1 Answer

0 votes
by

Create Job (--create)

Here we are creating a job with the name my job, which can import the table data from RDBMS table to HDFS. The following command is used to create a job that is importing data from the employee table in the db database to the HDFS file.

$ Sqoop job --create myjob \

--import \

--connect jdbc:mysql://localhost/db \

--username root \

--table employee --m 1

Verify Job (--list)

‘--list’ argument is used to verify the saved jobs. The following command is used to verify the list of saved Sqoop jobs.

$ Sqoop job --list

Inspect Job (--show)

‘--show’ argument is used to inspect or verify particular jobs and their details. The following command and sample output is used to verify a job called myjob.

$ Sqoop job --show myjob

Execute Job (--exec)

‘--exec’ option is used to execute a saved job. The following command is used to execute a saved job called myjob.

$ Sqoop job --exec myjob

Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

0 votes
asked Apr 13, 2020 in QuickTest Professional (QTP) by rajeshsharma
+2 votes
asked Jul 28, 2019 in R Language by Aarav2017
0 votes
asked Jan 21, 2020 in Agile by rahuljain1
0 votes
asked Dec 17, 2020 in SVN by SakshiSharma
0 votes
asked Jan 26, 2020 in Big Data | Hadoop by rajeshsharma
...