sqoop之旅2-基本使用

$ sqoop help

Available commands:
  codegen            Generate code to interact with database records   # 生成能够和数据库进行交互的代码
  create-hive-table  Import a table definition into Hive  # 将生成的Hive表导入Hive中
  eval               Evaluate a SQL statement and display the results  # 评估SQL语句，并且显示结果
  export             Export an HDFS directory to a database table  # 将HDFS目录导出到数据库表中
  help               List available commands  # 列出可用的命令
  import             Import a table from a database to HDFS  # 将一个表从数据库--->HDFS中
  import-all-tables  Import tables from a database to HDFS  # 将全部的表从数据表--->HDFS中
  import-mainframe   Import datasets from a mainframe server to HDFS   # 从服务器中将数据库导入到HDFS
  job                Work with saved jobs  # 工作与保存的任务
  list-databases     List available databases on a server  # 列出可用的数据库
  list-tables        List available tables in a database  # 列出数据库中的可用表
  merge              Merge results of incremental imports  # 合并增量导入的数据
  metastore          Run a standalone Sqoop metastore   # 运行一个独立的Sqoop元数据
  version            Display version information # 显示版本信息

(base) peter:sqoop-1.4.7 piqianchao$ sqoop help import

Common arguments:
   --connect <jdbc-uri>                         Specify JDBC connect
                                                string
   --connection-manager <class-name>            Specify connection manager
                                                class name
   --connection-param-file <properties-file>    Specify connection
                                                parameters file
   --driver <class-name>                        Manually specify JDBC
                                                driver class to use
   --hadoop-home <hdir>                         Override
                                                $HADOOP_MAPRED_HOME_ARG
   --hadoop-mapred-home <dir>                   Override
                                                $HADOOP_MAPRED_HOME_ARG
   --help                                       Print usage instructions
-P                                              Read password from console
   --password <password>                        Set authentication
                                                password
   --password-alias <password-alias>            Credential provider
                                                password alias
   --password-file <password-file>              Set authentication
                                                password file path
   --relaxed-isolation                          Use read-uncommitted
                                                isolation for imports
   --skip-dist-cache                            Skip copying jars to
                                                distributed cache
   --username <username>                        Set authentication
                                                username
   --verbose                                    Print more information
                                                while working

 # 1. 直接使用
sqoop import \
--connect jdbc:mysql://localhost/db \
--username foo \
--table TEST \

# 2. 将参数写入文件中
sqoop --options-file /users/home/work/import.txt --table TEST

# 每行一个参数
# /users/home/work/import.txt
import
--connect

jdbc:mysql://localhost/db
--username
foo