我已尝试此命令，但出现以下错误。。
命令：
sqoop import --connect jdbc:oracle:thin:@ip:1521:XE --username akash -P --table transactions_Oracle --coloumns "Tid,AccounID,Amount" --hive-import --hive table akash.Transactions_Oracle -m1错误：
16/07/13 00:13:38 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.7.0
Enter password:
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: --coloumns
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: Tid,AccounID,Amount
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: --hive-import
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: --hive
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: table
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: akash.Transactions_Oracle
16/07/13 00:13:41 ERROR tool.BaseSqoopTool: Unrecognized argument: -m1list database命令工作正常，但无法从表中导入数据。。
1条答案
按热度按时间mi7gmzs61#
正确的语法是：
sqoop import --connect jdbc:oracle:thin:@ip:1521:XE --username akash -P --table transactions_Oracle --columns "Tid,AccounID,Amount" --hive-import --hive-table akash.Transactions_Oracle -m 1你写的coloumns而不是columns,--hive table而不是--hive-table以及m1而不是m 1检查drill docs以了解import命令中各种标记的含义。