/bigdata/server/sqoop/../hbase does not exist! hbase imports will fail.

这个错误提示意味着你在使用Sqoop将数据导入到HBase时，Sqoop无法找到HBase的安装目录。

可能的原因是你在Sqoop命令中指定的HBase安装目录不正确，或者你没有正确地配置HBase环境变量。

你可以尝试重新指定HBase安装目录，或者检查你的HBase环境变量是否正确设置。例如：

sqoop import --connect jdbc:mysql://localhost:3306/mydatabase \
--username myuser --password mypassword \
--table mytable \
--hbase-table hbase_table \
--column-family cf \
--hbase-create-table \
--hbase-row-key id \
--hbase-home /path/to/hbase

其中，--hbase-home参数指定HBase的安装目录。你需要将/path/to/hbase替换为你的HBase安装目录。

相关问题

使用sqoop将数据从MySQL导入hive报错，Warning: /usr/local/sqoop-1.4.7/../hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. Warning: /usr/local/sqoop-1.4.7/../hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. Warning: /usr/local/sqoop-1.4.7/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. Warning: /usr/local/sqoop-1.4.7/../zookeeper does not exist! Accumulo imports will fail. Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation. No such sqoop tool: import--connect. See 'sqoop help'.

这个报错提示中包含了多个warning和一个错误，可以分别解决。

首先，warning提示了HBase、HCatalog、Accumulo和Zookeeper的路径不存在，这些都是一些可选的组件，如果你没有安装它们，就会出现这个warning，不会影响导入数据的操作，可以忽略这个warning。

其次，报错提示了"No such sqoop tool: import--connect"，这个错误一般是因为在sqoop的import命令中，少了一个空格，正确的命令应该是"sqoop import --connect"，你需要检查一下你的sqoop命令中是否少了空格，并且确认你的MySQL数据库是否已经启动、连接是否正确。

总结一下，你可以忽略warning信息，但需要检查一下sqoop import命令的格式并且确认MySQL数据库的连接是否正确。

[root@zhaosai conf]# sqoop import --connect jdbc:mysql://zhaosai:3306/mydb --username root --password jqe6b6 --table news --target-dir /user/news --fields-terminated-by “;” --hive-import --hive-table news -m 1 Warning: /opt/programs/sqoop-1.4.7.bin__hadoop-2.6.0/../hbase does not exist! HBase imports will fail. Please set $HBASE_HOME to the root of your HBase installation. Warning: /opt/programs/sqoop-1.4.7.bin__hadoop-2.6.0/../hcatalog does not exist! HCatalog jobs will fail. Please set $HCAT_HOME to the root of your HCatalog installation. Warning: /opt/programs/sqoop-1.4.7.bin__hadoop-2.6.0/../accumulo does not exist! Accumulo imports will fail. Please set $ACCUMULO_HOME to the root of your Accumulo installation. Warning: /opt/programs/sqoop-1.4.7.bin__hadoop-2.6.0/../zookeeper does not exist! Accumulo imports will fail. Please set $ZOOKEEPER_HOME to the root of your Zookeeper installation. 23/06/10 16:07:14 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7 23/06/10 16:07:15 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead. 23/06/10 16:07:15 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset. 23/06/10 16:07:15 INFO tool.CodeGenTool: Beginning code generation 23/06/10 16:07:15 ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver java.lang.RuntimeException: Could not load db driver class: com.mysql.jdbc.Driver at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:875) at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763) at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786) at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289) at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260) at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246) at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327) at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872) at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671) at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106) at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501) at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628) at org.apache.sqoop.Sqoop.run(Sqoop.java:147) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234) at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243) at org.apache.sqoop.Sqoop.main(Sqoop.java:252)

这段代码是使用 Sqoop 工具将 MySQL 数据库中的 news 表导入到 Hadoop 的 HDFS 中，并且使用 Hive 表示，并且在导入过程中使用了分隔符“;”。但是在执行过程中出现了一个异常，提示无法加载数据库驱动类 com.mysql.jdbc.Driver。可能是因为没有将 mysql-connector-java.jar 包添加到 Sqoop 的 classpath 中导致的。需要将该 jar 包添加到 Sqoop 的 lib 目录下，并重新执行该命令。