command-line operation of the Create command
1. Create Connection Function
Create connection--cid 1Description: Create New Connection object for connector with ID <x>
Sqoop the> Create Connection--cid1Creating Connection forConnector withID 1Please fill following values to create new connectionObjectname:jdbcconnection configurationjdbc Driver Class:com.mysql.jdbc.DriverJDBC Connection String:jdbc:mysql://hadoop000:3306/hiveUsername:rootpassword:****JDBC Connection Properties:there is currently0ValuesinchThe map:entry#security related configuration Optionsmax connections: -New Connection is successfully created with validation status FINE and persistentID 5
2. Create Job Function
Create job--xid 1Description: Create new Job Object for connection with ID <x>
Create job--xid 1--type ImportDescription: Create new Job Object with type <t> (import, export)
Sqoop the> Create Job--xid5--type importcreating Job forConnection withID 5Please fill following the values to create new jobObjectname:tbls_importdatabase configurationschema name:hivetable name:tblstable SQL statement:table column names: Partition column Name:nullsinchpartition column:boundary query:output configurationstorage type:0: Hdfschoose:0Output Format:0: Text_file1: Sequence_filechoose:0Compression Format:0: NONE1: DEFAULT2: DEFLATE3: GZIP4: BZIP25: LZO6: LZ47: Snappychoose:0Output Directory:hdfs://hadoop000:8020/sqoop2/tbls/throttling ResourcesExtractors:Loaders:New job was successfully created with validation status FINE and persistent
ID 3
command-line Action Show command
1. Show Server FunctionDescription: Show details about the configuration connection to Sqoop server.
Sqoop:> Show server-12000server webapp:sqoopsqoop:> show Server--hostserver host:localhostsqoop:> Show Server--12000sqoop: > Show Server--webappserver webapp:sqoop
2. Show Option FunctionShow values of various client side options. This function would show all client options when called without arguments.
Sqoop:> Show Option--false
3. Show Version FunctionShow versions of both client and server as well as supported protocols.
Sqoop the> Show Version--allclient Version:sqoop1.99.3-cdh5.0.0revision Unknown Compiled by Jenkins on Thu Mar - at: the: -Pdt theServer Version:sqoop1.99.3-cdh5.0.0revision Unknown Compiled by Jenkins on Thu Mar - at: the: -Pdt theProtocol version: [1]sqoop: the> Show Version--clientclient Version:sqoop1.99.3-cdh5.0.0revision Unknown Compiled by Jenkins on Thu Mar - at: the: -Pdt theSqoop: the> Show Version--Serverserver Version:sqoop1.99.3-cdh5.0.0revision Unknown Compiled by Jenkins on Thu Mar - at: the: -Pdt theSqoop: the> Show Version--protocolprotocol version: [1]
4. Show Connector FunctionShow connector meta data-parameters that connectors need in order to create new connection and Job objects.
Show Connector--all
5.
Show Connection Function
Show connection-5
6. Show Job Function
Show Job--4
command-line Operation Update command
1. Update Connection Function
1
2. Update Job Function
1
command-line operation of the Delete command
1. Delete Connection Function
1
2. Delete Job Function
1
Command line Operation clone command
1. Clone Connection Function
3
2. Clone Job Function
3
command-line Operation submission
1. Submission Start FunctionStart Job (submit new submission). Starting already running job is considered as invalid operation.
3 -S
2. Submission Stop FunctionInterrupt running job.
Stop Job 3
3. Submission Status FunctionRetrieve last status for given job.
3
SQOOP2 Common Command Introduction