![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sqoop
风继续吹-小海
love or hate me,the one or another
展开
-
sqoop:mysql import to hdfs
sqoop import –connect jdbc:mysql://localhost:3306/chen –username root –password 123 –table test 报错: Exception in thread “main” java.lang.NoClassDefFoundError: org/json/JSONObject at org.apache.sqo...原创 2018-11-09 10:15:54 · 300 阅读 · 0 评论 -
sqoop:mysql import to hive
导入hdfs 然后进行load data import to hive sqoop import –connect jdbc:mysql://localhost:3306/chen –username root –password 123 –table test –delete-target-dir –hive-import –hive-table test 导入分区表...原创 2018-11-09 10:18:50 · 215 阅读 · 0 评论 -
sqoop:oracle import to hdfs
spool 方式导出成文本,上传hadoop服务器 然后进行load data sqoop import –connect jdbc:oracle:thin:@oracle:1521:orac –username chen –password chen -m 1 –table TEST 连接方式: –connect jdbc:oracle:thin:@OracleServer:...原创 2018-11-09 10:25:44 · 218 阅读 · 0 评论 -
SQOOP 安装
1)下载 cdh 2)解压到~/app下 3)SQOOP_HOME export SQOOP_HOME=/home/hadoop/app/sqoop-1.4.6-cdh5.7.0 export PATH=$SQOOP_HOME/bin:$PATH 4)conf: $SQOOP_HOME/conf/sqoop-env.sh export HADOOP_COMMON_HOME=/home/hado...原创 2018-11-08 16:13:37 · 129 阅读 · 0 评论