尝试读取表参数时,sqoop作业失败 [英] sqoop job fails when trying to read table argument
本文介绍了尝试读取表参数时,sqoop作业失败的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我尝试将一些数据导入配置单元表,但我的sqoop作业失败
I am trying to import some data into a hive table but my sqoop job is failing
sqoop import -libjars '/var/lib/sqoop/DB2JccConfiguration.properties'
--connect 'jdbc:db2://localhost/test;' --username 'name'
--password-file 'pword' --num-mappers 16
--query "SELECT P_NUMBER,AG, EFFECTIVE_DATE, EXPIRATION_DATE, ST, ZIP FROM wU99.snapshot WHERE ZIP = 15392 AND \$CONDITIONS"
--split-by 'AG'--hive-import --hive-table ag.test
--target_dir '/user/name/Test'
Warning: /opt/cloudera/parcels/CDH-5.8.3-1.cdh5.8.3.p2036.2124/bin/../lib/sqoop/../accumulo does not exist!
Accumulo imports will fail.Please set $ACCUMULO_HOME to the root of your Accumulo installation.
17/05/03 16:21:10 INFO sqoop.Sqoop: Running Sqoop version: 1.4.6-cdh5.8.3
17/05/03 16:21:12 ERROR tool.BaseSqoopTool: Error parsing arguments for import:
17/05/03 16:21:12 ERROR tool.BaseSqoopTool: Unrecognized argument: AG--hive-import
17/05/03 16:21:12 ERROR tool.BaseSqoopTool: Unrecognized argument: --hive-table
17/05/03 16:21:12 ERROR tool.BaseSqoopTool: Unrecognized argument: ag.test
17/05/03 16:21:12 ERROR tool.BaseSqoopTool: Unrecognized argument: --target_dir
17/05/03 16:21:12 ERROR tool.BaseSqoopTool: Unrecognized argument: /user/name/Test
我不知道为什么它在尝试读取表时失败。任何帮助将不胜感激。
I don't know why it is failing when it tries to read the table. Any help would be appreciated.
推荐答案
sqoop import -libjars'/ var / lib / sqoop / DB2JccConfiguration .properties'
--connect'jdbc:db2:// localhost / test;'--username'name'
--password-file'pword'--num-mappers 16
--querySELECT P_NUMBER,AG,EFFECTIVE_DATE,EXPIRATION_DATE,ST,ZIP FROM wU99.snapshot WHERE ZIP = 15392 AND \ $ CONDITIONS
--split-by'AG'--hive-database'your_database_name' --hive-import
--target-dir'/ user / name / Test'
这篇关于尝试读取表参数时,sqoop作业失败的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文