大门的博客

部署 安装解压并做软链接 [hadoop@10-9-15-140 soft]$ pwd /home/hadoop/soft [hadoop@10-9-15-140 soft]$ wget http://archive.cloudera.com/cdh5/cdh/5/sqoop-1.4.6-cdh5.7.0.tar.gz [hadoop@10-9-15-140 soft]$ tar -zxvf sq...

19/07/31 00:41:49 INFO mapreduce.ImportJobBase: Beginning import of city_info Exception in thread “main” java.lang.NoClassDefFoundError: org/json/JSONObject at org.apache.sqoop.util.SqoopJsonUtil.getJ...

sqoop 导入hive 报错FAILED: SemanticException [Error 10072]: Database does not exist: xxxx 解决方法：复制hive/conf下的hive-site.xml到sqoop工作目录的conf下 实际上该database是在hive中存在的，由于sqoop下的配置文件太旧引起的，一般会出现在,换台机器执行sqoop CDH 默...

sqoop导入hive表示报错 19/07/31 01:16:17 ERROR hive.HiveConfig: Could not load org.apache.hadoop.hive.conf.HiveConf. Make sure HIVE_CONF_DIR is set correctly. 19/07/31 01:16:17 ERROR tool.ImportTool: Encount...

现有城市信息和产品信息两张表在MySQL中，另外有用户点击产品日志以文本形式存在hdfs上，现要求统计每个个城市区域下点击量前三的产品名，具体信息见下方。 DROP TABLE city_info; CREATE TABLE city_info ( city_id int DEFAULT NULL, city_name varchar(255) DEFAULT NULL, area v...