【CentOS】Sqoop连接数据库报错

【CentOS】Sqoop连接数据库报错

安装好Sqoop后尝试安装mysql数据库，结果报错：

[hadoop@master ~]$ sqoop list-database --connect jdbc:mysql://127.0.0.1:3306/ --username root -pWarning: /usr/local/src/sqoop/../hbase does not exist! HBase imports will fail.Please set $HBASE_HOME to the root of your HBase installation.Warning: /usr/local/src/sqoop/../hcatalog does not exist! HCatalog jobs will fail.Please set $HCAT_HOME to the root of your HCatalog installation.Warning: /usr/local/src/sqoop/../accumulo does not exist! Accumulo imports will fail.Please set $ACCUMULO_HOME to the root of your Accumulo installation.No such sqoop tool: list-database. See 'sqoop help'.

HBase、hcatalog、accumulo三个组件我都没有安装，所以要修改sqoop安装目录bin文件夹下的 ​​configure-sqoop​​ 文件，找到如下位置并注释：

第一部分：## Moved to be a runtime check in sqoop.if [ ! -d "${HBASE_HOME}" ]; then echo "Warning: $HBASE_HOME does not exist! HBase imports will fail." echo 'Please set $HBASE_HOME to the root of your HBase installation.'fi## Moved to be a runtime check in sqoop.if [ ! -d "${HCAT_HOME}" ]; then echo "Warning: $HCAT_HOME does not exist! HCatalog jobs will fail." echo 'Please set $HCAT_HOME to the root of your HCatalog installation.'fiif [ ! -d "${ACCUMULO_HOME}" ]; then echo "Warning: $ACCUMULO_HOME does not exist! Accumulo imports will fail." echo 'Please set $ACCUMULO_HOME to the root of your Accumulo installation.'fiif [ ! -d "${ZOOKEEPER_HOME}" ]; then echo "Warning: $ZOOKEEPER_HOME does not exist! Accumulo imports will fail." echo 'Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation.'fi第二部分：export HBASE_HOMEexport HCAT_HOMEexport HIVE_CONF_DIRexport ACCUMULO_HOMEexport ZOOKEEPER_HOME

将以上两部分注释候，重新进行sqoop对MySQL数据库的连接就可以了，并且显示的数据库与MySQL保持一致：

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。