使用sqoop从oracle导入数据

Question

我正在使用以下命令将表导入从oracle使用sqoop的hadoop。但我得到错误。因为我在hadoop noob，我不知道如何解决它。

sqoop import --connect "jdbc:oracle:thin:@172.16.10.112:1523:TABS" --username testuser1 --password testuser1 --table tabs.user_info --target-dir /tmp –verbose 


Generic Hadoop command-line arguments: 
(must preceed any tool-specific arguments) 
Generic options supported are 
-conf <configuration file>  specify an application configuration file 
-D <property=value>   use value for given property 
-fs <local|namenode:port>  specify a namenode 
-jt <local|resourcemanager:port> specify a ResourceManager 
-files <comma separated list of files> specify comma separated files to be copied to the map reduce cluster 
-libjars <comma separated list of jars> specify comma separated jar files to include in the classpath. 
-archives <comma separated list of archives> specify comma separated archives to be unarchived on the compute machines. 

The general command line syntax is 
bin/hadoop command [genericOptions] [commandOptions] 


At minimum, you must specify --connect and --table 
Arguments to mysqldump and other subprograms may be supplied 
after a '--' on the command line. 

Answer 1

冗长的短划线（ - ）不同

Answer 2

您不应该在表格选择中指定数据库。由于数据库TABS在连接字符串已经选定，

更换，

--table tabs.user_info 

与

--table user_info 

让我知道这对你的作品。