SQOOP2 Common Command Introduction

Source: Internet
Author: User
Tags sqoop

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.