sqoop导出到mysql数据库

sqoop:000> create job --xid 1 --type export
Creating job for connection with id 1
Please fill following values to create new job object
Name: export_emp

Database configuration

Schema name: schools
Table name: emp
Table SQL statement:
Table column names:
Stage table name:
Clear stage table:

Input configuration

Input directory: /opt/hadoop/mysql/emp

Throttling resources

Extractors:
Loaders:
New job was successfully created with validation status FINE  and persistent id 4
sqoop:000> show job
+----+-------------+--------+-----------+---------+
| Id |    Name     |  Type  | Connector | Enabled |
+----+-------------+--------+-----------+---------+
| 1  | mysqlImport | IMPORT | 1         | true    |
| 2  | emp_dept    | IMPORT | 1         | true    |
| 3  | testExport  | EXPORT | 1         | true    |
| 4  | export_emp  | EXPORT | 1         | true    |
+----+-------------+--------+-----------+---------+
sqoop:000> start job --jid 4
Submission details
Job ID: 4
Server URL: http://hadoopMaster:12000/sqoop/
Created by: hadoop
Creation date: 2014-05-30 12:58:53 CST
Lastly updated by: hadoop
External ID: job_local1529531301_0004
    http://localhost:8080/
2014-05-30 12:58:53 CST: BOOTING  - Progress is not available

 

 

mysql> select * from emp;
+----+-----------+
| id | name      |
+----+-----------+
|  1 | Dennis-1  |
|  2 | Dennis-2  |
|  3 | Dennis-3  |
|  4 | Dennis-4  |
|  5 | Dennis-5  |
|  6 | Dennis-6  |
|  7 | Dennis-7  |
|  8 | Dennis-8  |
|  9 | Dennis-9  |
| 10 | Dennis-10 |
| 11 | Dennis-11 |
| 12 | Dennis-12 |
| 13 | Dennis-13 |
| 14 | Dennis-14 |
| 15 | Dennis-15 |
| 16 | Dennis-16 |
| 17 | Dennis-17 |
| 18 | Dennis-18 |
| 19 | Dennis-19 |
| 20 | Dennis-20 |
+----+-----------+
20 rows in set (0.00 sec)