| sqoop-job(1) |
| ============ |
| |
| NAME |
| ---- |
| sqoop-job - Define, execute, and manipulate saved Sqoop jobs. |
| |
| SYNOPSIS |
| -------- |
| 'sqoop-job' <generic-options> <tool-options> [-- [<subtool-name>] |
| <subtool-options>] |
| |
| 'sqoop job' <generic-options> <tool-options> [-- [<subtool-name>] |
| <subtool-options>] |
| |
| |
| DESCRIPTION |
| ----------- |
| |
| include::../user/job-purpose.txt[] |
| |
| OPTIONS |
| ------- |
| |
| One of the job operation arguments is required. |
| |
| Job management options |
| ~~~~~~~~~~~~~~~~~~~~~~ |
| |
| --create (job-id):: |
| Define a new saved job with the specified job-id (name). A |
| second Sqoop command-line, separated by a +--+ should be specified; |
| this defines the saved job. |
| |
| --delete (job-id):: |
| Delete a saved job. (This deletes the job definition, but does not |
| remove any data from HDFS.) |
| |
| --exec (job-id):: |
| Given a job id defined with +--create+, run the saved job. Any arguments |
| following a +--+ are applied on top of the saved job, overriding the saved |
| parameters. |
| |
| --show (job-id):: |
| Shows the parameters for a saved job |
| |
| --list:: |
| List all saved jobs |
| |
| |
| Metastore connection options |
| ~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| |
| By default, Sqoop will use a private, local embedded database to store saved |
| jobs. An alternate metastore can be configured in +conf/sqoop-site.xml+. You |
| can also specify the metastore connect string here: |
| |
| --meta-connect (jdbc-uri):: |
| Specifies the JDBC connect string used to connect to the metastore |
| |
| --meta-user:: |
| Specify a jdbc connection username to a database. Default value is 'SA' |
| |
| --meta-password:: |
| Specify a jdbc connection password to a database. Default value is empty string. |
| |
| Common options |
| ~~~~~~~~~~~~~~ |
| |
| --help:: |
| Print usage instructions |
| |
| --verbose:: |
| Print more information while working |
| |
| EXAMPLES |
| -------- |
| |
| Listing available jobs in the metastore: |
| sqoop job --list --meta-connect jdbc:oracle:thin:@//myhost:1521/ORCLCDB |
| --meta-username ms_user --meta-password ms_password |
| |
| Creating a new job in the metastore: |
| sqoop job --create myjob1 --meta-connect jdbc:oracle:thin:@//myhost:1521/ORCLCDB |
| --meta-username ms_user --meta-password ms_password -- import |
| --connect jdbc:mysql://mysqlhost:3306/sqoop --username sqoop --password sqoop --table "TestTable" -m 1 |
| |
| Executing an existing job: |
| sqoop job --exec myjob1 --meta-connect jdbc:oracle:thin:@//myhost:1521/ORCLCDB |
| --meta-username ms_user --meta-password ms_password |
| |
| Showing the definition of an existing job: |
| sqoop job --show myjob2 --meta-connect jdbc:oracle:thin:@//myhost:1521/ORCLCDB |
| --meta-username ms_user --meta-password ms_password |
| |
| Deleting an existing job: |
| sqoop job --delete myjob1 --meta-connect jdbc:oracle:thin:@//myhost:1521/ORCLCDB |
| --meta-username ms_user --meta-password ms_password |
| |
| ENVIRONMENT |
| ----------- |
| |
| See 'sqoop(1)' |
| |
| |
| //// |
| Copyright 2011 The Apache Software Foundation |
| |
| Licensed to the Apache Software Foundation (ASF) under one |
| or more contributor license agreements. See the NOTICE file |
| distributed with this work for additional information |
| regarding copyright ownership. The ASF licenses this file |
| to you under the Apache License, Version 2.0 (the |
| "License"); you may not use this file except in compliance |
| with the License. You may obtain a copy of the License at |
| |
| http://www.apache.org/licenses/LICENSE-2.0 |
| |
| Unless required by applicable law or agreed to in writing, software |
| distributed under the License is distributed on an "AS IS" BASIS, |
| WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| See the License for the specific language governing permissions and |
| limitations under the License. |
| //// |
| |