sqoop进口没有命令未能发现错误
问题描述:
我试图直接导入SQL Server表到HBase的,下面是sqoop进口语法sqoop进口没有命令未能发现错误
sqoop import --connect "jdbc:sqlserver://server_IP:port;databaseName=xxx" --username xxx --password xxx --table sqoop_HBase--hbase-table employeeHBase --column-family amitesh --hbase-row-key empid --hbase-create-table -m 1
在这里,我面临两个问题
1)如果我正在采取的jdbc:SQLSERVER:// SERVER_IP:口;的databaseName = XXX双引号中,我得到以下错误
5 06:02:05 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6_IBM_27
17/06/05 06:02:05 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: employeeHBase
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: --column-family
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: amitesh
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: --hbase-row-key
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: empid
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: --hbase-create-table
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: -m
17/06/05 06:02:05 ERROR tool.BaseSqoopTool: Unrecognized argument: 1
2)当我撤消了双引号,并执行命令,我收到以下错误
--table or --query is required for import. (Or use sqoop import-all-tables.)
Try --help for usage instructions.
-bash: --username: command not found
我很确定我迷糊的命令syntax.May是我错了。
答
必须有空间--table sqoop_HBase
和--hbase-table employeeHBase
之间我已经尝试进行更改,仍然没有工作 – user3521180
嘿,谢谢你指出的问题。它的工作像魅力 – user3521180
@ user3521180快乐的帮助.. :) –