sqoop小作业
实现需求:1) city_info表存在MySQL 2) product_info表存在MySQL3) user_click数据导入Hive4) 三表的join 取TOP3(按区域进行分组)按天分区表5) 查询结果导入到MySQL数据库最终的统计结果字段如下:product_id 商品IDproduct_name 商品名称area 区域click_count 点击数/访问量rank ...
sqoop部署及导入与导出
1.sqoop安装? ??CDH之sqoop下载地址:http://archive.cloudera.com/cdh5/cdh/5一.下载及环境配置wget http://archive.cloudera.com/cdh5/cdh/5/sqoop-1.4.6-cdh5.7.0.tar.gztar -zxvf?/sqoop-1.4.6-cdh5.7.0.tar.gz?-C ~/app[hadoop@hadoop001 conf]$ vim ~/.bash_profileexport ...
【大数据】— sqoop ?
sqoop介绍