随笔分类 -  sqoop

sqoop 创建job时 java.lang.NoClassDefFoundError: org/json/JSONObject
摘要：缺少jar包 到maven仓库下载json in java 之后把jar包上传至sqoop的lib目录下即可 阅读全文
posted @ 2018-11-26 15:24 tele 阅读(2031) 评论(0) 推荐(0)
sqoop 1.4.7 安装配置/连接测试
摘要：环境: hadoop2.7.7 mysql 8 zk 3.4.10 hive 3 1.上传并解压tar包后进入conf目录 拷贝sqoop-env-template.sh并重命名为sqoop-env.sh(conf目录下已经有了sqoop-site.xml) 2.编辑sqoop-env.sh,添加如 阅读全文
posted @ 2018-11-25 15:31 tele 阅读(434) 评论(0) 推荐(0)
ERROR sqoop.Sqoop: Got exception running Sqoop: java.lang.RuntimeException: java.lang.RuntimeException: java.sql.SQLException: The connection property 'zeroDateTimeBehavior' acceptable values are: 'CO
摘要：使用sqoop导入数据时报了如题的异常,异常的提示是 The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 阅读全文
posted @ 2018-11-25 14:35 tele 阅读(9108) 评论(1) 推荐(1)