在尝试使用sqoop从mysql导入数据到hive时遇到错误。问题在于sqoop无法自动找到本地的hive环境。解决方法是手动配置sqoop的hive环境，包括将sqoop-env-template.sh重命名为sqoop-env.sh，并在文件中设置HIVE_HOME环境变量为hive的安装目录。
执行 ./sqoop create-hive-table --connect jdbc:mysql://192.168.1.10:3306/ekp_11 --table job_log --username root --password 123456 --hive-table job_log
准备将关系型数据的表结构复制到hive中。但是提示如下一堆错误信息：
Warning: /usr/lib/hbase does not exist! HBase imports will fail.Please set $HBASE_HOME to the root of your HBase installation.
Warning: /usr/lib/hcatalog does not exist! HCatalog jobs will fail.
Please set $HCAT_HOME to the root of your HCatalog installation.
15/08/02 02:04:14 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
15/08/02 02:04:14 INFO tool.BaseSqoopTool: Using Hive-specific delimiters for output. You can override
15/08/02 02:04:14 INFO tool.BaseSqoopTool: delimiters with --fields-terminated-by, etc.
15/08/02 02:04:14 INFO manager.MySQLManager: Preparing to use a MySQ
最低0.47元/天 解锁文章
491
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
