1. $ bin/sqoop help create-hive-table
  2. usage: sqoop create-hive-table [GENERIC-ARGS] [TOOL-ARGS]
  4. Common arguments:
  5.    --connect <jdbc-uri>                         Specify JDBC connect
  6.                                                 string
  7.    --connection-manager <class-name>            Specify connection manager
  8.                                                 class name
  9.    --connection-param-file <properties-file>    Specify connection
  10.                                                 parameters file
  11.    --driver <class-name>                        Manually specify JDBC
  12.                                                 driver class to use
  13.    --hadoop-home <hdir>                         Override
  14.                                                 $HADOOP_MAPRED_HOME_ARG
  15.    --hadoop-mapred-home <dir>                   Override
  16.                                                 $HADOOP_MAPRED_HOME_ARG
  17.    --help                                       Print usage instructions
  18. -P                                              Read password from console
  19.    --password <password>                        Set authentication
  20.                                                 password
  21.    --password-alias <password-alias>            Credential provider
  22.                                                 password alias
  23.    --password-file <password-file>              Set authentication
  24.                                                 password file path
  25.    --relaxed-isolation                          Use read-uncommitted
  26.                                                 isolation for imports
  27.    --skip-dist-cache                            Skip copying jars to
  28.                                                 distributed cache
  29.    --username <username>                        Set authentication
  30.                                                 username
  31.    --verbose                                    Print more information
  32.                                                 while working
  34. Hive arguments:
  35.    --create-hive-table                         Fail if the target hive
  36.                                                table exists
  37.    --hive-database <database-name>             Sets the database name to
  38.                                                use when importing to hive
  39.    --hive-delims-replacement <arg>             Replace Hive record \0x01
  40.                                                and row delimiters (\n\r)
  41.                                                from imported string fields
  42.                                                with user-defined string
  43.    --hive-drop-import-delims                   Drop Hive record \0x01 and
  44.                                                row delimiters (\n\r) from
  45.                                                imported string fields
  46.    --hive-home <dir>                           Override $HIVE_HOME
  47.    --hive-overwrite                            Overwrite existing data in
  48.                                                the Hive table
  49.    --hive-partition-key <partition-key>        Sets the partition key to
  50.                                                use when importing to hive
  51.    --hive-partition-value <partition-value>    Sets the partition value to
  52.                                                use when importing to hive
  53.    --hive-table <table-name>                   Sets the table name to use
  54.                                                when importing to hive
  55.    --map-column-hive <arg>                     Override mapping for
  56.                                                specific column to hive
  57.                                                types.
  58.    --table <table-name>                        The db table to read the
  59.                                                definition from
  61. Output line formatting arguments:
  62.    --enclosed-by <char>               Sets a required field enclosing
  63.                                       character
  64.    --escaped-by <char>                Sets the escape character
  65.    --fields-terminated-by <char>      Sets the field separator character
  66.    --lines-terminated-by <char>       Sets the end-of-line character
  67.    --mysql-delimiters                 Uses MySQL's default delimiter set:
  68.                                       fields: ,  lines: \n  escaped-by: \
  69.                                       optionally-enclosed-by: '
  70.    --optionally-enclosed-by <char>    Sets a field enclosing character
  72. Generic Hadoop command-line arguments:
  73. (must preceed any tool-specific arguments)
  74. Generic options supported are
  75. -conf <configuration file>     specify an application configuration file
  76. -D <property=value>            use value for given property
  77. -fs <local|namenode:port>      specify a namenode
  78. -jt <local|jobtracker:port>    specify a job tracker
  79. -files <comma separated list of files>    specify comma separated files to be copied to the map reduce cluster
  80. -libjars <comma separated list of jars>    specify comma separated jar files to include in the classpath.
  81. -archives <comma separated list of archives>    specify comma separated archives to be unarchived on the compute machines.
  83. The general command line syntax is
  84. bin/hadoop command [genericOptions] [commandOptions]
  87. At minimum, you must specify --connect and --table

复制表结构

  1. $ bin/sqoop create-hive-table \
  2. --connect jdbc:oracle:thin:@//192.168.1.38:1521/CMASPROD \
  3. --username mes_bc \
  4. --password-file 38oracle.pwd \
  5. --mysql-delimiters \
  6. --table H_LOG_LOTBASE