cdh5.14 sqoop 问题记录

sqoop1 client报错:

Warning: /opt/cloudera/parcels/CDH-5.12.0-1.cdh5.12.0.p0.29/bin/../lib/sqoop/../accumulo does not exist! Accumulo imports will fail.

Please set $ACCUMULO_HOME to the root of your Accumulo installation.

解决：
mkdir /var/lib/accumulo
export ACCUMULO_HOME=/var/lib/accumulo

参考:http://www.cnblogs.com/haoqin-1/p/7522382.html

导入数据的时候出现Unsupported major.minor version 52.0的问题描述

由于cloudera manager和系统的jdk版本不一致导致的,其中cm的jdk版本低,而系统的版本高!

原因:虽然cdh5.14支持jdk8,但是安装时使用了jdk7,所以会报错.

将机器中的jdk改回1.7

导入数据hang在Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-5.14.0-1.cdh5.14.0.p0.24/jars/hive-common-1.1.0-cdh5.14.0.jar!/hive-log4j.properties

参考:https://community.cloudera.com/t5/Hadoop-101-Training-Quickstart/Unable-to-import-data-from-mysql-to-hive-using-sqoop/m-p/40480

http://www.aboutyun.com/thread-18763-1-1.html

解决:hdfs权限改为777,

办法:查hive日志HIVESERVER & HIVEMETASTORE

权限参考:https://blog.csdn.net/qq_22690765/article/details/77004862

导入数据显示异常:

换行符和date变string截断 : https://blog.csdn.net/jiangsanfeng1111/article/details/53334819

null值变字符串null : https://blog.csdn.net/u012965373/article/details/53899717

导入注意点:https://blog.csdn.net/zleven/article/details/53781111

技巧 :http://www.cnblogs.com/cenyuhai/p/3306037.html

http://www.aboutyun.com/thread-9638-1-1.html

http://willgo.cc/blog/2015/05/16/sqoop-spacil-chart.html