How can you choose a name for the mapreduce job which is created on su

1.	How can you choose a name for the mapreduce job which is created on submitting a free-form query import?
Answer» By using the --mapreduce-job-name parameter. Below is a example of the command. sqoop import \--connect jdbc:mysql://mysql.example.com/sqoop \--username sqoop \--password sqoop \--query 'SELECT normcities.id, \countries.country, \normcities.city \FROM normcities \JOIN countries USING(country_id) \WHERE $CONDITIONS' \--split-by id \--target-dir cities \--mapreduce-job-name normcities

How can you choose a name for the mapreduce job which is created on submitting a free-form query import?

Answer»

By using the --mapreduce-job-name parameter. Below is a example of the command.

sqoop import \--connect jdbc:mysql://mysql.example.com/sqoop \--username sqoop \--password sqoop \--query 'SELECT normcities.id, \countries.country, \normcities.city \FROM normcities \JOIN countries USING(country_id) \WHERE $CONDITIONS' \--split-by id \--target-dir cities \--mapreduce-job-name normcities

Discussion

No Comment Found

Related InterviewSolutions

Where can the metastore database be hosted?
Which database the sqoop metastore runs on?
Give the sqoop command to see the content of the job named myjob?
How can you see the list of stored jobs in sqoop metastore?
What is the purpose of sqoop-merge?
What is a sqoop metastore?
Give a command to execute a stored procedure named proc1 which exports data to from MySQL db named DB1 into a HDFS directory named Dir1.
Give a sqoop command to import data from all tables in the MySql DB DB1.
What does the following query do?$ sqoop import --connect jdbc:mysql://db.foo.com/somedb --table sometable \ --where "id > 1000" --target-dir /incremental_dataset --append
Give a Sqoop command to import all the records from employee table divided into groups of records by the values in the column department_id.

How can you choose a name for the mapreduce job which is created on submitting a free-form query import?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment