8. sqoop-import-all-tables
8.1. Purpose
import-all-tables命令导入一堆表格到HDFS,
每个表的数据存储在独立的HDFS目录里。
下列条件必须满足:
每个表必须有单列的主键
导入每个表的所有列
You must not intend to use non-default splitting column, nor impose any conditions via a WHERE clause.
8.2. Syntax
略
8.3. Example Invocations
从corp数据库里导入所有表格:
$ sqoop import-all-tables --connect jdbc:mysql://db.foo.com/corp
验证是否OK:
$ hadoop fs -ls
Found 4 items
drwxr-xr-x - someuser somegrp 0 2010-04-27 17:15 /user/someuser/EMPLOYEES
drwxr-xr-x - someuser somegrp 0 2010-04-27 17:15 /user/someuser/PAYCHECKS
drwxr-xr-x - someuser somegrp 0 2010-04-27 17:15 /user/someuser/DEPARTMENTS
drwxr-xr-x - someuser somegrp 0 2010-04-27 17:15 /user/someuser/OFFICE_SUPPLIES